Backup

I am having a problem with a backup.
I have a bakup of a Database "mydb.bak" 2-years old.

I am using diffrent  types of backups but getting en error?

1. How can i find out the name of the DB
2. Filegroups in this backup.
3. getting problems with physical & logical names.

anyone
shanjAsked:
Who is Participating?
 
Daniel_PLConnect With a Mentor DB Expert/ArchitectCommented:
RESTORE FILELISTONLY FROM DISK='<path to your file>'
RESTORE HEADERONLY FROM DISK='<path to your file>'
You're gonna see contents of your backup file.
0
 
ThakurVinayCommented:
what error are you getting?
what version of sql server are you using?

verify the backup also.

restore verifyonly from disk=""

HTH
Vinay
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.