asked on

SQL Server 2005 Restore multiple databases from one device

I backed up multiple databases to a single backup device in SQL Server 2005.

If I look at the content I see all the DB Backups properly listed. However if I go to restore any database I can only restore the first database that's in the backup device. If I run the command
"Restore FileListOnly From <device>" I only see the first database backup!

Is it possible to restore each database? If, yes how?

chapmandew

there should be an option for you to check which db you want to restore....

chapmandew

for example, i did a quick backup 3 times to the same file, and show here how I could restore the middle one if I wanted:
restoremulti.JPG

lostlinkpr

ASKER

--Update--

If I run the command "Restore headerOnly from <backup-device>" I do get the entire list of databases.

@chapmandew
I did do that already and it does list all DB backups but after selecting any of the backup listed it always tries to restore the first one. When I go to options on the left-side menu I can see that the DB name of the database is trying to restore matches the DB Backup #1.

For instance

lostlinkpr

ASKER

I have increased the points for this question.
Please provide any advise possible.
Thanks!

ASKER CERTIFIED SOLUTION

chapmandew

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

lostlinkpr

ASKER

I tested the backup on a 2008 instance and I have no issues, so I upgraded mine from 2005 on dev and it works well.

@Chapmandew I tried your command and it listed the specific backup. Then ran the restore database command with the same parameters and it worked. Therfore I'm giving you the points.

Thank you!

chapmandew

awesome!

lostlinkpr

ASKER

Gave partially on "Easy to follow" because I had to figure out how to restore the DB from command line by looking at documentation. (I'm not a DBA).