I'm not able to restore a Database from 2005 onto 2008. It may be damaged but it's very large and from another country - it took 5 days to copy the file here. Here are the details of what I ran into - if anyone has any ideas, please let me know...
I tried the restore - error:
RESTORE detected an error on page (0:0) in database "..." as read from the backup set.
Then I tried RESTORE VERIFYONLY:
Attempting to restore this backup may encounter storage space problems. Subsequent messages will provide details.
The path specified by "I:....MDF" is not in a valid directory.
Directory lookup for the file "L:....LDF" failed with the operating system error 2(failed to retrieve text for this error. Reason: 15105).
Msg 3189, Level 16, State 1, Line 1
Damage to the backup set was detected.
Msg 3013, Level 16, State 1, Line 1
VERIFY DATABASE is terminating abnormally.
So I tried a restore with CONTINUE_AFTER_ERROR. Error:
Converting database '...' from version 611 to the current version 661.
Database '...' running the upgrade step from version 611 to version 621.
Msg 601, Level 12, State 3, Line 1
Could not continue scan with NOLOCK due to data movement.
Damage to the backup set was detected.
RESTORE WITH CONTINUE_AFTER_ERROR was successful but some damage was encountered. Inconsistencies in the database are possible.
And currently when I try any statement on the Database I get:
Cannot open database '...' version 611. Upgrade the database to the latest version.