Link to home
Create AccountLog in
Avatar of anushahanna
anushahannaFlag for United States of America

asked on

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
Avatar of anushahanna
anushahanna
Flag of United States of America image

ASKER


RESTORE VERIFYONLY FROM DISK = 'E:\backups\tracker.bak' gives
The backup set on file 1 is valid.
ASKER CERTIFIED SOLUTION
Avatar of EvilPostIt
EvilPostIt
Flag of United Kingdom of Great Britain and Northern Ireland image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
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?
yes - restore command worked (on same backup file).. is there any setting that needs turned on for gui?
SOLUTION
Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
>>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?
SOLUTION
Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
thanks for your help.