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
Author
Message
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


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 2:48 AM
Points: 42,438, Visits: 35,493
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 2008, 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