September 5, 2010 at 2:08 pm
Hi,
I try to restore sql 2000 database in sql 2008 database server and I am getting following error message in the restoration process.
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 'ohmis'.
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.
Please suggest, how i can solve this issues?
Is any option to get more details of this error?
Thanks in advance
September 5, 2010 at 4:12 pm
Anything more in the SQL error log?
From the looks of the error, either the backup is damaged or the original database is corrupt.
Can you get another backup to try?
Can you run the following on the SQL 2000 DB?
DBCC CHECKDB (<Database Name>) WITH NO_INFOMSGS, ALL_ERRORMSGS
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
September 5, 2010 at 4:35 pm
What do you get back from running restore verifyonly on the backup that you are trying to use?
Joie Andrew
"Since 1982"
September 5, 2010 at 4:45 pm
Joie Andrew (9/5/2010)
What do you get back from running restore verifyonly on the backup that you are trying to use?
Worth noting that without checksum backups (2005+), restore verify only checks the backup header and a couple other things. It does not check the integrity of the entire backup.
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