Changing Default SQL Server Backup Folder in SQL Server 2008
March 20, 2010
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.
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.
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.
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.
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...
Geeks who read this article also read…
- Installing SQL Server 2008 R2 on Windows Server 2008 R2
- Database Backup Compression Feature In SQL Server 2008
- New Date and Time Data Types in SQL Server 2008
- Date and Time Functions in SQL Server 2008
- Using Transparent Data Encryption Feature of SQL Server 2008
- Microsoft SQL Server 2008 and 2005 Build Versions
- How to identify if the database was upgraded from a previous version of SQL Server
- Read More SQL Server Articles…