Set the default backup location in MSSQL 2008

Created by: Brendan Bone
Created date:
Last Updated date:


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



  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
Was this article helpful?
1 out of 2 found this helpful
Have more questions? Submit a request


Powered by Zendesk