Solved

HEADERONLY gives a row back, but cannot see backup sets in GUI

Posted on 2011-02-14
8
340 Views
Last Modified: 2012-05-11
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
0
Comment
Question by:anushahanna
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 5
  • 3
8 Comments
 
LVL 6

Author Comment

by:anushahanna
ID: 34891022

RESTORE VERIFYONLY FROM DISK = 'E:\backups\tracker.bak' gives
The backup set on file 1 is valid.
0
 
LVL 16

Accepted Solution

by:
EvilPostIt earned 500 total points
ID: 34916335
Have you tried doing actually doing a restore database SQL command against it as it could be the gui acting up...
0
 
LVL 6

Author Comment

by:anushahanna
ID: 34916902
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
Three Reasons Why Backup is Strategic

Backup is strategic to your business because your data is strategic to your business. Without backup, your business will fail. This white paper explains why it is vital for you to design and immediately execute a backup strategy to protect 100 percent of your data.

 
LVL 6

Author Comment

by:anushahanna
ID: 34917133
yes - restore command worked (on same backup file).. is there any setting that needs turned on for gui?
0
 
LVL 16

Assisted Solution

by:EvilPostIt
EvilPostIt earned 500 total points
ID: 34917613
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
 
LVL 6

Author Comment

by:anushahanna
ID: 34922468
>>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
 
LVL 16

Assisted Solution

by:EvilPostIt
EvilPostIt earned 500 total points
ID: 34924102
Yes that will be why. Compressed backups only came along in SQL 2008.
0
 
LVL 6

Author Comment

by:anushahanna
ID: 34928867
thanks for your help.
0

Featured Post

Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
Sometimes drives fill up and we don't know why.  If you don't understand the best way to use the tools available, you may end up being stumped as to why your drive says it's not full when you have no space left!  Here's how you can find out...
This tutorial will give a an overview on how to deploy remote agents in Backup Exec 2012 to new servers. Click on the Backup Exec button in the upper left corner. From here, are global settings for the application such as connecting to a remote Back…
This tutorial will walk an individual through locating and launching the BEUtility application to properly change the service account username and\or password in situation where it may be necessary or where the password has been inadvertently change…

739 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question