June 23, 2013 at 4:56 am
Dear all,
My server OS(win2003:Raid5) was corrupted while I am taking my backup(SQL2000). Some how I restored the backup file & tried to restore, but unfortunately default SQL restore database restore gives me the below error:
"Microsoft SQL-DMO (ODBC SQLState: 42000)
An Internal consistency error occurred. Contact Technical Supoort for assitance.
RESTORE DATABASE is terminating abnirmally."
Then, I used "RESTORE HEADERONLY " command and giving me a 1 record with "*** INCOMPLETE ***" as the BackupName.
"RESTORE VERIFYONLY" command is giving me:
Server: Msg 3242, Level 16, State 2, Line 1
The file on device 'path' is not a valid Microsoft Tape Format backup set.
Server: Msg 3013, Level 16, State 1, Line 1
VERIFY DATABASE is terminating abnormally.
If I use, "RESTORE DATABASE" with file=1 command is giving me the below error:
Server: Msg 5243, Level 22, State 1, Line 1
An inconsistency was detected during an internal operation. Please contact technical support. Reference number 5.
Connection Broken
Could you please help me to restore this database, at least with selected 1 or 2 tables?
June 23, 2013 at 5:30 am
Try RESTORE ... WITH CONTINUE_AFTER_ERROR on SQL 2005 or above
It's highly unlikely to work, but you can try. If it doesn't work, then the backup is useless.
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 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply