Search code examples
sql-serverssms

Backup file is not visible in SQL Server Management Studio

In Microsoft SQL Server Management Studio, I right click on a database, select Tasks and then Backup. For destination there is this destination : 

 C:\Program Files\Microsoft SQL Server\MSSQL12.MSSQLSERVER\MSSQL\Backup

When I click OK, it says

The backup of database 'mydb' completed successfully

But when I navigate to that folder written above, folder looks empty. Why is it empty? Why can't I see the backup files? What am I doing wrong? Thanks.

Solution

  • The backup file exist on the path you entered but on the same server that has the database. So, unless you are running the SQL Server instance on your local machine, you should remotely connect to the server that hosts SQL Server and copy the backup from there.