I am restoring a SQL Server 2005 database onto a SQL Server 2008 R2 instance using this command:
RESTORE DATABASE SampleDB FROM DISK= 'C:\SampleProject\SampleDB.bak' WITH REPLACE, MOVE 'sampledb' TO 'C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\SampleDB.mdf', MOVE 'sampledb_log' TO 'C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\SampleDB_log.ldf', CONTINUE_AFTER_ERROR, STATS = 10;
And the output is:
10 percent processed. 20 percent processed. 30 percent processed. 40 percent processed. 50 percent processed. 60 percent processed. 70 percent processed. 80 percent processed. 90 percent processed. 100 percent processed. Msg 3242, Level 16, State 2, Line 3 The file on device 'C:\SampleProject\SampleDB.bak' is not a valid Microsoft Tape Format backup set. Msg 3013, Level 16, State 1, Line 3 RESTORE DATABASE is terminating abnormally.
Why does the processed percent reach 100% but then terminate abnormally?
How can I restore this database backup even with corrupt data? Continue-after-error does not appear to make any difference.