SQL Server 2011 (Denali): Changing Backup Files Default Path

Up to SQL Server 2008 R2 (10.5), we were unable to change default path (easily) for “Backup files”, though it was possible after making some changes in registry at path. “HKEY_LOCAL_MACHINE\SOFTWARE\ Microsoft\Microsoft SQL Server\MSSQL.1\ MSSQLServer\BackupDirectory”

Note: For SQL Server 2005 its MSSQL.1, for SQL Server 2008, its MSSQL10 and for SQL Server 2008 R2 its MSSQL10_50

 

Thanks to SQL Server 2011 (Code name DENALI), as now we can change this default path for backup files to our required one by just opening server properties page and on “Database Settings” tab.

Try Taking a backup from SSMS and now you can find that it has already pointing toward you given path.

------------------------------------------------------------------------------------
Read More about SQL Server 2012 (Code Name: Denali) 

·         Introducing New Edition "Business Intelligence"

·         New Backup/Restore Options

·         CTP 3 Product Guide Released

·         TRY_CONVERT(), a Good Addition

·         Table Partition Limit Enhancement

·         Format(), a Most Wanted Function

·         Get Date/Time from Parts

·         New Function to Get Last Date of Month

·         IIF Logical Function

·         A New More Flexible Create Index Dialog box