HEADERONLY gives a row back, but cannot see backup sets in GUI
RESTORE HEADERONLY FROM DISK = 'E:\backups\tracker.bak' returns a row, but when i try to use the backup to restore, it does not show any backup set info under "Specify the source and location of backup sets to restore" From Device:
the backup is zipped with sql 2008- could that be an issue?
thanks
the backup is zipped with sql 2008- could that be an issue?
thanks
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
OK- the code seems to be running.. will take a while.. will update you.
my version is 10.0.4000.0 (X64)- that should not be a problem, should it?
my version is 10.0.4000.0 (X64)- that should not be a problem, should it?
ASKER
yes - restore command worked (on same backup file).. is there any setting that needs turned on for gui?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
>>may just be a some sort of escape character missing from somewhere...
if i choose a 2005 normal backup, it picks it up fine, but a compressed 2008 backup, it shows blank. my ssms is 2005 sp3- could that be?
if i choose a 2005 normal backup, it picks it up fine, but a compressed 2008 backup, it shows blank. my ssms is 2005 sp3- could that be?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
thanks for your help.
ASKER
RESTORE VERIFYONLY FROM DISK = 'E:\backups\tracker.bak' gives
The backup set on file 1 is valid.