Browsing the blog archives for February, 2015

Change Default Backup Location on SQL Server

This is just a quick post of a task that seldom needs to happen… Changing the default location of the backup directory. There is no way to change this setting in SSMS… The quickest way is to use an extended stored procedure. [sourcecode language='sql' padlinenumbers='true'] DECLARE @BackupDirectory VARCHAR(100) EXEC master..xp_regread @rootkey='HKEY_LOCAL_MACHINE', @key='SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQLServer', @value_name='BackupDirectory', […]

0 Comments