FAQ: How to change the SQL backup directory

[jeremy_sg]

Where the Vault repository backups are stored is determined by how your copy of SQL is configured. In the registry, there's a key that controls the default backup directory for SQL Server. If that key is missing, the backup location defaults to the System32 directory. Adding a string value to:

Code: Select all

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\MSSQLServer

with the name of "BackupDirectory" and the value of the directory path eg.:

Code: Select all

C:\Program Files\Microsoft SQL Server\MSSQL\BACKUP

will set the default backup directory.