At Percona’s web store you can order your MongoDB database support needs in minutes. No hassles, no fuss, just pick and click. Pay online with a credit card. Handle your MongoDB database support now!
COURSE of the MONTH
8 days, 8 hours left to enrollBecome a Premium Member and unlock a new, free course in leading technologies each month.
Solved
RESTORE situation
Posted on 2014-12-13
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.
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
-
2
- +1
5 Comments
Can you run a dbcc checkdb with data_purity against the 2005 database?
Also I think each SQL Server version has a minimum compatibility level and anything below that will get raised. Nothing can be done about that.
Also I think each SQL Server version has a minimum compatibility level and anything below that will get raised. Nothing can be done about that.
dbcc checkdb with data_purity
says only
Command(s) completed successfully.
>>SQL Server version has a minimum compatibility level and anything below that will get raised.
we are restoring a 90 version db from 2005 on 2008 server. that should be no issue,right? can you clarify, please?
says only
Command(s) completed successfully.
>>SQL Server version has a minimum compatibility level and anything below that will get raised.
we are restoring a 90 version db from 2005 on 2008 server. that should be no issue,right? can you clarify, please?
Active today
Do you have at least the SP4 installed in the SQL Server 2005 instance?
Also the SQL Server 2008R2 instance should has SP3 installed.
Also the SQL Server 2008R2 instance should has SP3 installed.
In case of backup/restore you can try to copy your database, start it in your 2008-management studio
http://msdn.microsoft.com/en-us/library/ms188664(v=sql.105).aspx
http://msdn.microsoft.com/en-us/library/ms188664(v=sql.105).aspx
>>Also the SQL Server 2008R2 instance should has SP3 installed.
2005 is @ 9.00.5069.00 and 2008R2 @ 10.50.6000.34
>>In case of backup/restore you can try to copy your database, start it in your 2008-management studio
I will propose this. if it is not a 'AS IS' copy (backup/restore) generally we have to engage the vendor to get approval.
2005 is @ 9.00.5069.00 and 2008R2 @ 10.50.6000.34
>>In case of backup/restore you can try to copy your database, start it in your 2008-management studio
I will propose this. if it is not a 'AS IS' copy (backup/restore) generally we have to engage the vendor to get approval.
Featured Post
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
This article explains how to reset the password of the sa account on a Microsoft SQL Server. The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
A Stored Procedure in Microsoft SQL Server is a powerful feature that it can be used to execute the Data Manipulation Language (DML) or Data Definition Language (DDL).
Depending on business requirements, a single Stored Procedure can return differe…
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
Suggested Courses
Course of the Month8 days, 8 hours left to enroll
765 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.