Home > Net >  In SQL Server Management Studio 2018 unable to find "Device" on restore database screen
In SQL Server Management Studio 2018 unable to find "Device" on restore database screen

Time:03-05

I am trying to restore "wideworldimporters-Full.bak" database in management studio 2018. The instructions to restore it states to select device option which I don't see on restore database screen. Instead, it has backup file browse option which I tried but it gives a system error that it cannot find the file (I think it is looking for .abf file).

I would appreciate any help in restoring the database so that I can follow the PBI course.

CodePudding user response:

In the Object Explorer (left) right click "Databases" and select "Restore Database". In the dialog that pops up, be sure on the left "General" is selected and you should see the "Device" option then.

Select restore database

Select device

  • Related