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
LVL 6
anushahannaAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
EvilPostItConnect With a Mentor Commented:
Have you tried doing actually doing a restore database SQL command against it as it could be the gui acting up...
0
 
anushahannaAuthor Commented:

RESTORE VERIFYONLY FROM DISK = 'E:\backups\tracker.bak' gives
The backup set on file 1 is valid.
0
 
anushahannaAuthor Commented:
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?
0
Has Powershell sent you back into the Stone Age?

If managing Active Directory using Windows Powershell® is making you feel like you stepped back in time, you are not alone.  For nearly 20 years, AD admins around the world have used one tool for day-to-day AD management: Hyena. Discover why.

 
anushahannaAuthor Commented:
yes - restore command worked (on same backup file).. is there any setting that needs turned on for gui?
0
 
EvilPostItConnect With a Mentor Commented:
Not that i know of, may just be a some sort of escape character missing from somewhere..... Its always best to know the actual commands rather than just doing it through the gui...
0
 
anushahannaAuthor Commented:
>>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?
0
 
EvilPostItConnect With a Mentor Commented:
Yes that will be why. Compressed backups only came along in SQL 2008.
0
 
anushahannaAuthor Commented:
thanks for your help.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.