September 5, 2010 at 2:03 pm
When i restore the SQL 2000 ENT. DB to SQL 2008 ENT.Server i am getting the following message:
100 percent processed.
Processed 5935600 pages for database 'xxxx', file xxxx_Data' on file 1.
Processed 369 pages for database 'ohmis', file 'xxxx_Log' on file 1.
Msg 3167, Level 16, State 4, Line 1
RESTORE could not start database 'xxxx'.
Msg 3013, Level 16, State 1, Line 1
RESTORE DATABASE is terminating abnormally.
Msg 3414, Level 21, State 1, Line 1
An error occurred during recovery, preventing the database 'xxxx' (database ID 6) from restarting. Diagnose the recovery errors and fix them, or restore from a known good backup. If errors are not corrected or expected, contact Technical Support.
How i can solve this issue?
September 5, 2010 at 4:11 pm
Please don't cross post. It just wastes peoples time and fragments replies.
No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic980836-1550-1.aspx
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 2, 2011 at 10:19 am
Dear All,
Sqlserver 2000 is production server.
Sqlserver 2008 is yet to bring production server.
I am trying to migrate from sqlserver 2000 to sqlserver 2008R2, but i am facing this error....
possible schema corruption,Run DBCC checkcatalog [Microsoft sqlserver error code:211
Kindly anyone can help me,Its very urgent.....
my mail id : gsundaram@softcell.in
regards,
Sundaram G
March 2, 2011 at 12:53 pm
gsundaram (3/2/2011)
I am trying to migrate from sqlserver 2000 to sqlserver 2008R2, but i am facing this error....possible schema corruption,Run DBCC checkcatalog [Microsoft sqlserver error code:211
So did you do what the error said and run DBCC CheckCatalog?
When did you get this error?
When did you last run checkDB on the SQL 2000 server?
When did you last run checkCatalog on the SQL 2000 server?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply