Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

Restore Incomplete BAK file Expand / Collapse
Posted Sunday, June 23, 2013 4:56 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, June 24, 2013 4:50 AM
Points: 2, Visits: 11
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?
Post #1466513
Posted Sunday, June 23, 2013 5:30 AM



Group: General Forum Members
Last Login: Yesterday @ 2:07 PM
Points: 43,451, Visits: 40,592

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
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #1466516
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse