Cool Tips‎ > ‎Backup and Restore‎ > ‎

Retrieve Default Backup Location

Applicability:

                 SQL Server 2000:        Not Tested
                 SQL Server 2005:        Tested
                 SQL Server 2008:        Tested
                 SQL Server 2008R2:    Tested
                 SQL Server 2012:        Tested
                 SQL Server 2014:        Tested
                 SQL Server 2016:        Tested
                 SQL Server 2017:        Not Tested        

Credits:

Author:  ChillyDBA
Date:      6 Jun 2020

Description

Retrieve the default backup location folder from the registry.
Useful when writing dynamic management/ETL code

Code

EXECUTE [master].dbo.xp_instance_regread N'HKEY_LOCAL_MACHINE', N'SOFTWARE\Microsoft\MSSQLServer\MSSQLServer', N'BackupDirectory'




ċ
Andy Hughes,
Jun 6, 2020, 7:42 AM
Comments