Forum Discussion
Solved
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...
Thanks, that worked!!
I don't know how I missed it!!
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.