Follow

Set the default backup location in MSSQL 2008

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

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

Comments

Powered by Zendesk