I am trying to restore a 2005 database to a 2008 database. This is the code that was generated by Management studio:
View Complete Post
Restore 2005 database on 2008 R2 Trial I've downloaded SQL Server 2008 R2 Trial and installed it on Windows Server 2008 trial running under Virtual PC on XP. I've made backups of databases on my SQL Server 2005 and tried to restore them using
a) the wizard - results in a messagebox saying "Specified cast is not valid" and no backup sets are available in the Restore Database window.
b) using T-SQL - results in
Msg 3183, Level 16, State 2, Line 1
RESTORE detected an error on page (0:0) in database "dp" as read from the backup set.
Msg 3013, Level 16, State 1, Line 1
RESTORE DATABASE is terminating abnormally.
Using the wizard and RESTORE on 2005 for the same database backup works fine.
c) Detach on 2005 and Attach on 2008 results in: SQL Server detected a logical consistency-based I/O error: incorrect pageid...
Detach and Attach worked fine on 2005 and DBCC CHECKDB revealed no errors.
Thanks for any info...