Click here to monitor SSC
SQLServerCentral is supported by Redgate
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: Saturday, December 3, 2016 5:18 AM
Points: 45,619, Visits: 44,147

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

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