February 15, 2011 at 7:07 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?
thank you
February 15, 2011 at 7:24 am
In the restore syntax, you can specify the file number. To restore the first, FILE = 1, to restore the second, FILE = 2
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
February 15, 2011 at 7:31 am
thank you for the reply:
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.
Can i do something about it?
February 15, 2011 at 7:33 am
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.
February 15, 2011 at 7:34 am
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?
February 15, 2011 at 7:51 am
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....
February 15, 2011 at 8:27 am
I cannot remember if SQL2000 gave a specific exception if you tried to restore a backup produced by a more recent version of SQL server.
It may be worth finding out what version of SQL server your client is using.
(eg If the db is running in 2000 compatibility mode on a 2005 or 2008 server, then you will not be able to restore the db to SQL2000.)
Alternatively, you could try restoring the db on a more recent version of SQL.
February 15, 2011 at 11:19 am
The backup is toast, get hold of a new one.
There's nothing surprising about verify only succeeding and restore failing. Verify only does not guarantee that the backup is restorable, it checks headers and a few other bits.
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
February 15, 2011 at 11:21 am
Ken McKelvey (2/15/2011)
I cannot remember if SQL2000 gave a specific exception if you tried to restore a backup produced by a more recent version of SQL server.
It was a very odd error, iirc it was something about exceeding the maximum number of database files. It wasn't smart enough to say 'this backup is too new'
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
Viewing 9 posts - 1 through 9 (of 9 total)
You must be logged in to reply to this topic. Login to reply