I have a db in SQL 200-5 .. i need to bring to 2008. When I do a simple BR or detach/attach on 2008, it fails. The restore happens fine, but when it tries to bring the db online, it fails.
in the error log, it has observed the below:
During upgrade, database raised exception 211, severity 23, state 27
RESTORE could not start db
RESTORE DATABASE' is terminating abnormally.
Possible Schema Corruption-.
When I run CHECKDB, CHECKCATALOG on the original database, it comes back fine.
When I try to restore the backup onto another database name in the 2005 server, it works fine to restore a new database. but if a 2008 server, then the issue.
i create 2 dummy databases in 2005 from scratch (one 80 and another 90 mode), made backup and restored into 2008 and they worked fine.
need to also mention that the compatability is still 80 on the 2005 server database. it has to come to 2008r2 wtih higher compatability.