Forum Discussion

MurraySobol985's avatar
MurraySobol985
Copper Contributor
Jun 06, 2025

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

5 Replies

Sort By
  • RandyLP7's avatar
    RandyLP7
    Copper Contributor
    Jun 09, 2025

    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.

    • MurraySobol985's avatar
      MurraySobol985
      Copper Contributor
      Jun 09, 2025

      Using previous version of SSMS, select database,  chose Backup.

  • RandyLP7's avatar
    RandyLP7
    Copper Contributor
    Jun 08, 2025

    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.

Resources