Sql-server – .bak file not visible for restoration

backuprestoresql serversql-server-2012

There is a database on a server of which I would like a copy on my local machine for testing purposes, so I created a backup in the default disk location (C:\Program Files (x86)\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\Backup). The backup dialog says it completes successfully, but when I go to restore the .bak, it's not visible to the file selection dialog (significant file names blurred, obviously).

enter image description here

There are other viable backups in the same location, but the one I supposedly created does not appear. When attempting to recreate the backup, the one I created appears as a selectable option, while the others in the folder do not.

enter image description here

What is the issue here? I don't think it's a permissions problem because I'm able to access the other backups in the same folder.

Edit: The backup was on the server which has a similar file structure to my machine. I remoted in to the server and copied the file. Thanks for the help!

Best Answer

You did not save the files where you think you did.

In the first image there are 9 folders below 'Microsoft SQL Server' and above 'MSSQL11.MSSQLSERVER' in the second screen shot there are only 5.

This is possibly an issues with your local machine VS a seperate server. Assuming the address you are following are identical (C:\Program Files (x86)\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\Backup) the only solution remaining is that the C drives are on different machines.

Related Question