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....