Forum Discussion
problem restoring a backup
I have a backup file (xxxx.bak) in my c:\trmp directory.
When I launch SSMS signed on as "sa" and try to restore this database, i get this window:
I am not able to enter anything for "Database" and the dropdown is empty.
Then if I switch it to "Device" I get this window:
Now, under "Destination" I am able to enter a database name, i.e. the name I want the database to be referred to after I restore it.
However, note the message at the top of the window: No backupset selected to be restored.
How do I resolve this issue?
Murray
Thanks, that worked!!
I don't know how I missed it!!
8 Replies
Thought I posted a reply, but I do not see it now, so I will try a repost.
Click the [...] button behind the "Devices" which will bring up an Open File popup window.
Locate your xxxx.bac file and select the file.
SSMS will then read the xxxx.bac file and fill in a bunch of fields.
You can then change any fields need you need to adjust and continue with the Restore.
How did you make the backup file?
Using previous version of SSMS, select database, chose Backup.
Click the [...] button behind the "Devices" and use the [Open File] popup to find your xxx.bak file and select it.
SSMS will read the information from the xxx.bak file and fill in a bunch of fields.
You can then go make any changes you need to make before doing the actual restore.Thanks, that worked!!
I don't know how I missed it!!
I'm happy you managed to solve your issue, but you really should have marked RandyLP7's reply as the solution, and not your "that worked"-message.
