restore database in ssms 2017 selected bak file in device option and showing nothing in Backup sets to restore option and disable Ok button too

Question

I am trying to restore sample database adventureworks in SSMS 2017 right Click in Database selected Restore Database in Device option then option ADD selected AdventureWorks2017.bak file in my hard drive c:\Microsoft SQL Server\MSSQL14.MSSQLSERVER_2017\MSSQL\Backup press Ok and nothing showing in Destination and Backup sets to retore and disable Ok Button in this Window (filled in Destination Database) the same

could somebody help me thank you

I am reinstall sql server with standard version 2016 to try restore database in this version?? — osk, Aug 20 '18 at 12:23

score 0 · Accepted Answer · answered Oct 02 '18 at 15:24

Move the file to default backup repository for SqlServer: C:\Program Files\Microsoft SQL Server\MSSQL[##].[instanceName]\MSSQL\Backup

or check the permissions for this folder, to find the SQL Instance username... to add that user to permissions for the folder where the .bak file resides

restore database in ssms 2017 selected bak file in device option and showing nothing in Backup sets to restore option and disable Ok button too

1 Answers1

Linked