Situatie
When trying to restore a database from one SQL instance to another SQL instance, the .bak files are not available for selection in SQL Server Management Studio. They exist in the folder, but SSMS cannot find them. This prevents the restore process.
Solutie
Pasi de urmat
This is a permissions issue. The logon account for the SQL Server service does not have permissions to the Backup folder. Open services.msc and navigate to the SQL Server service for your instance.
Navigate to the Log On page and copy the account used to log on.
Navigate to your Backup folder and open the Properties dialog of the folder. Under the Security tab, select the Edit button and add the account from the previous step. In this example, the account is MSSQL$RAULSINSTANCE. In the permissions box, provide full control to the service account.
Now you should see the .bak backup files in SQL Server Management Studio and can select them to be restored.
Leave A Comment?