SQL Server 2000 Restore - Missing Logical Names

When I try and restore a database from a backup device (.bak), I cannot see the logical file names inside the file and I'm unable to restore the backup.  I've tried multiple backup devices with no luck.
michaeldepasqualeAsked:
Who is Participating?
 
chapmandewConnect With a Mentor Commented:
did you try to get the logical names from here?

restore filelistonly from disk = 'c:\backup.bak'
0
 
michaeldepasqualeAuthor Commented:
I'm not sure what you mean.  Do I run this in Query Analyzer?
0
 
chapmandewCommented:
yeah, run it in QA and point it to your backup file (what you're trying to restore).  It contains the logical names that you need.
0
Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
michaeldepasqualeAuthor Commented:
When I tried it on the backup device, I get "Device Error or Device Off-Line".  Just to be sure, I tried a different database and it worked fine.
0
 
chapmandewCommented:
so, you have the backup as a backup device and not a file?
0
 
michaeldepasqualeAuthor Commented:
It's a .bak file
0
 
chapmandewCommented:
so, it works for one backup file but not another?
0
 
michaeldepasqualeAuthor Commented:
Correct.  When I tried that command on a database that I just backed up, it came back clean.  When I tried it on the one that was pulled from the tapes, it errored out.

Just for laughes, I typed the logical names manually in and it returned the same error message through the restore GUI as through QA.

I don't know if the client ever verified that the backups worked, but since the .bak files are a decent size, I assume that something is in them.
0
 
chapmandewCommented:
hmmm.....dont know what to tell you there.  Sounds to me like something might be wrong w/ them.  Are they on your local machine?
0
 
michaeldepasqualeAuthor Commented:
Funny thing now - we took the .bak files and were able to successfully restore them on a different SQL Server.  Now I'll just detach them and re-attach them on the original server.  I'll let you know if that works.
0
 
chapmandewCommented:
OK...hope it does.
0
 
michaeldepasqualeAuthor Commented:
Turns out it was the startup account on the SQL Server service.  When the client reinstalled SQL, they set it to a certain account.  When we switched it to System Account, the backups worked just fine.  Thanks for the help.
0
 
chapmandewCommented:
very welcome.
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.