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.
Could you please help me to restore this database, at least with selected 1 or 2 tables?