Can't restore backup....

Last Post 05 Feb 2013 09:01 AM by Jeff Freedman. 10 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
river1
New Member
New Member

--
15 Feb 2011 05:57 AM

Hi,

Some client sent me a backup so i can restore it.

I was trying to restore the database but keep receiving the massage that there are concistency errors in the backup file.

I have made a restore headeronly procedure and discovered that inside the file there are two backups.

the information is this:

First backu0p startdate =2011-01-12 14:35:23.000 first backup finish date =2011-01-12 14:35:31.000

Second backup startdate =2011-02-07 14:59:34.000 finish date = NULL


I just want to restore the second backup, how can i accomplish this?


when i try to restore like this:


restore database SGT11 from disk='D:\DBs\recup\Backup_RFVT_SGT_07--01-2011.BAK' with file=2


i receive the following SQL Server error:

Server: Msg 3242, Level 16, State 2, Line 1
The file on device 'D:\DBs\recup\Backup_RFVT_SGT_07--01-2011.BAK' is not a valid Microsoft Tape Format backup set.
Server: Msg 3013, Level 16, State 1, Line 1
RESTORE DATABASE is terminating abnormally.


If i do with file =1 i receive the following error: Server: Msg 3270, Level 16, State 1, Line 1 An internal consistency error occurred. Contact Technical Support for assistance. Server: Msg 3013, Level 16, State 1, Line 1 RESTORE DATABASE is terminating abnormally.


the two backups are in the same file with the name =Backup_RFVT_SGT_07--01-2011.BAK
But if i do a restore headeronly i can see the two backups inside the file.... I really need this backups... How can i restore them?


When i do this: restore verifyonly from disk ='D:\DBs\recup\Backup_RFVT_SGT_07--01-2011.BAK' SQL Server sends this message: The backup set is valid. very strange....



rm
New Member
New Member

--
15 Feb 2011 06:27 AM
That means the db is corrupted already when took backup, let them fix the db and backup again.
river1
New Member
New Member

--
15 Feb 2011 06:50 AM
i can not , this database is now corrupted....

we only have this backup. We can´t even restore the first backup from file?
gunneyk
New Member
New Member

--
15 Feb 2011 08:14 AM
Is it possible the backup is from a more recent version of SQL Server than what you are using to restore it?
river1
New Member
New Member

--
15 Feb 2011 08:22 AM
No, that's not possible...

The two are SQL Server 2000 instances.

I have tried this:

RESTORE DATABASE SGT1 FROM DISK='D:\DBs\recup\Backup_RFVT_SGT_07--01-2011.BAK'
WITH REPLACE, CONTINUE_AFTER_ERROR

but still an error ocourrs:


Msg 3186, Level 16, State 2, Line 1
The backup set has been damaged. RESTORE will not attempt to apply this backup set.
Msg 3013, Level 16, State 1, Line 1
RESTORE DATABASE is terminating abnormally.
rm
New Member
New Member

--
15 Feb 2011 11:40 AM
Not much you can do with it.
river1
New Member
New Member

--
17 Feb 2011 03:06 AM
We could not recover the information....

They are inserting all the information by hand!

Is it possible that this backup file may become corrupt due to a HD failure?
rm
New Member
New Member

--
17 Feb 2011 04:47 AM
Possible, did you have any?
river1
New Member
New Member

--
17 Feb 2011 05:00 AM
yes, we had
lucycook
New Member
New Member

--
17 Jul 2012 04:21 AM
Dear Revier,

First i want to say you that it may be possible your sql database corrupted this is why you not restore your backup, for restore your all data you should be used a data recovery software for sql
repair there are so may software which can help you to restore your old data one of them is Kernel for SQL repair you can try it and download from here restoresqldatabase.org
Jeff Freedman
New Member
New Member

--
05 Feb 2013 09:01 AM
The first .bak file was created within 10 seconds, unlikely for big- or medium-size dbs. Probably there was backup failure. I also recommend free or paid backup tools for your use in future. http://www.sqlbackupandftp.com :)
You are not authorized to post a reply.

Acceptable Use Policy