Changing Default SQL Server Backup Folder in SQL Server 2008

By: Editor
March 20, 2010

Introduction

Can you explain me how can I change the default SQL Server Backup Folder in SQL Server 2008? In this article we will go through the steps which can be followed to change the Default SQL Server Backup Folder in SQL Server 2008 Using Policy Based Management Feature. These steps are applicable on SQL Server 2008 and higher versions.

1. Using SQL Server Management Studio, connect to SQL Server Database Engine.

2. In Object Explorer right click the SQL Server Database Engine Instance and choose Facets from the popup menu as shown in the snippet below.

Changing Default SQL Server Backup Folder Location in SQL Server 2008 Using Policy Based Management

3. In View Facets select Facet as Server Settings and change the value of BackupDirectory Facet Property to the New Folder Location where you want to save your database backups in future and click OK to save the changes.

View Facets Server Setting Using Policy Based Management



4. Moreover, you can also change the Default Data File and Default Log File location by specifying the values in DefaultFile and DefaultLog Facets properties respectively. Read the following article Changing the default location of SQL Server Data and Log files to know more about changing default location of SQL Server Data and Log files using SQL Server Management Studio in SQL Server 2005 and higher versions.

5. Internally, SQL Server executes the xp_instance_regwrite undocumented extended stored procedure to update the registry values. In order to makes these changes you should have admin privileges on the SQL Server and you should also have permissions to edit the REGISTRY values on the server.

Important Note

Once you have updated the SQL Server Backup Folder location go ahead and restart the SQL Server Services for the new values to come into effect.

Conclusion

In this article you have seen how easily one can change the SQL Server Backup Folder using Policy Based Management Feature of SQL Server 2008.

Continue Free Learning...

  • Please leave below your valuable feedback for this article.
  • Feel Free to refer this article to your friends and colleagues using the below “Share this Article” option.
  • Do subscriber to our News Letter to continue your free learning.
  • Don’t forget to Like Us on Facebook and do follow us on Twitter for latest updates.

Share this Article

Geeks who read this article also read…



Follow @MyTechMantra on Twitter
We're on Facebook
Bookmark and Share

"Receive newsletters and special offers about SQL Server, BizTalk and SharePoint from MyTechMantra. We respect you privacy and you can unsubscribe at any time."