December 7, 2011 at 6:04 am
Hi all,
I had an issue around backups today which I am very confused about....
A customer called me asking for me to perform a recovery of their database to yesterday at 15:30, not a problem as I have weekly full, dail diff and 3 hourly transaction backups configured.... or so i thought I wouldn't have a problem.
When I tried to do a restore (using the Gui) the restore failed as the full backup file could not be found, although the error message didn't list the file name itself it listed its id identifier e.g. {7AC...etc}. The first thing I noticed was that the full backup listed in the restore Gui had all the file attributes,lsn etc that you would expect but no "Name". I queried the backupmediafamily table held in msdb and found the relevant full backup with the id ({7AC...etc}) and noticed that all other backups had the full file location instead but this one only had the ID... so I updated the physical_device_name column for the relevant backup with the full path and name of the backup hoping it would populate the gui... but no.
So I ran through the restore (still using the gui) restoring the full and then each trans backup manfully - this worked as expected.
Just out of curiosity I tried the first restore again by selecting all of the options I required... i.e overwrite etc.. and used the script out to a new query window option. What i found has really stumped me... the first restore command which points to the full backup starts with - RESTORE DATABASE [DB NAME] FROM TAPE = N'E:\Program Files\Microsoft...etc..) why is it trying to go to tape?? Especially when the location provided in the command is to disk?? As soon as I change TAPE to DISK its fine but why does SSMS think its gone off to tape. I checked the Maintenance plan that I created to perform the backups and they are all point to disk!!
Any suggestions? Or am I going mad?
December 7, 2011 at 7:48 am
you want to restore transaction backups and diff backup you must have a full backup
the error is say the your lsn is not sequence
December 7, 2011 at 8:31 am
I have a full, diff and all transaction log backups that are required to perform the point in time restore, the two issue I am having are:
1, The full backups name does not populate in the SSMS restore gui - the diff and trans all have the name field populated.
2, When i use the script tool from the restore gui, and script it to a new query window the command line for the full backup restore is pointing to tape although its provides the correct file location (on disk)... if i change Tape to Disk it works fine as expected, however why, when the gui job is scripted would it think that the full backup is on tape instead of disk.... especially when it provide the correct disk location in the same line?
I think this is whats stopping the gui from being able to perform the restore as it thinks the full backup is on tape and not disk... even though it shows the correct path and file.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply