Avatar of 25112
25112

asked on 

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.
Microsoft SQL Server 2005Microsoft SQL Server 2008Microsoft SQL Server

Avatar of undefined
Last Comment
25112
SOLUTION
Avatar of Matt Bowler
Matt Bowler
Flag of New Zealand image

Blurred text
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
Avatar of 25112
25112

ASKER

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?
SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER CERTIFIED SOLUTION
Avatar of jogos
jogos
Flag of Belgium image

Blurred text
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
Avatar of 25112
25112

ASKER

>>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.
Microsoft SQL Server
Microsoft SQL Server

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

171K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
Ask the experts
Read over 600 more reviews

TRUSTED BY

IBM logoIntel logoMicrosoft logoUbisoft logoSAP logo
Qualcomm logoCitrix Systems logoWorkday logoErnst & Young logo
High performer badgeUsers love us badge
LinkedIn logoFacebook logoX logoInstagram logoTikTok logoYouTube logo