title: Restore SQL 2008 database fails with error on page xxx:xxx
body: <p>This is the situation:</p>
  
  <p>Got a full backup (.bak file) of a SQL 2008 database, with partitions.
  The .bak file is 100gb.</p>
  
  <p>I need to restore this database on a different server, to a new database.
  So, command is like this:</p>
  
  <pre><code>Restore Database [newname] FROM DISK= N'D:\mydatabase.bak' WITH FILE = 1
  MOVE 'mydatabasename' TO 'C:\mydatabase.mdf'
  MOVE 'Partition1' TO 'C:\`mydatabase_1.ndf'
  etc..
  STATS = 1
  </code></pre>
  
  <p>After 52 percent processed, I get this error:</p>
  
  <pre><code>Msg 3183, Level 16, State 2, Line 1
  RESTORE detected an error on page (8481:555819297) in database "dbname" as read from the backup set.
  Msg 3013, Level 16, State 1, Line 1
  RESTORE DATABASE is terminating abnormally.
  </code></pre>
  
  <p>Before all default suggestions come up, this is what I have already done:</p>
  
  <ul>
  <li>Checkdb on original database --> no errors</li>
  <li>Restore the .bak file on my local machine --> no errors, so the backup is correct.</li>
  </ul>
  
  <p>What can I do to troubleshoot this? How can I get to the actual problem?</p>
  
  <p>Thanks for any suggestions.</p>