Forum Discussion
MurraySobol985
Jun 06, 2025Copper Contributor
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...
- Jun 13, 2025
Thanks, that worked!!
I don't know how I missed it!!
RandyLP7
Jun 08, 2025Copper Contributor
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.
- MurraySobol985Jun 13, 2025Copper Contributor
Thanks, that worked!!
I don't know how I missed it!!
- SivertSolemJun 27, 2025Iron Contributor
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.
- MurraySobol985Jun 27, 2025Copper Contributor
SivertSolem: You are correct, but it appears no that I don't have the ability mark the message as "Resolved".
Murray
- MurraySobol985Jun 25, 2025Copper Contributor
Solved!!