Question

How do I change the default backup location in MSSQL 2012?

 

Answer

  1. Open up SQL Server Management Studio
  2. In the Object Explorer pane, right-click your database instance and click Properties
  3. On the left, select the Database Settings page
  4. Change the Backup entry to the desired backup folder, then click OK
  5. Restart the SQL Server service