Why Experts Exchange?
Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.
Jim Murphy
Programmer at Smart IT Solutions
When asked, what has been your best career decision?
Deciding to stick with EE.
Mohamed Asif
Technical Department Head
Being involved with EE helped me to grow personally and professionally.
Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question
Connect with Certified Experts to gain insight and support on specific technology challenges including:
Troubleshooting
Research
Professional Opinions
Ask a QuestionDid You Know?
We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE
troubleshooting Question
RESTORE situation
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.
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.
Our community of experts have been thoroughly vetted for their expertise and industry experience.