Question

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

 

Answer

  1. Open up SQL Server Management Studio
  2. In the Object Explorer pane, right-click your database instance and click Facets
  3. In the Facet drop-down select Server Settings
  4. Change the BackupDirectory entry to the desired backup folder, then click OK
  5. Restart the SQL Server service