FAQ: How to change the SQL backup directory

A collection of information about Vault, including solutions to common problems.

Moderator: SourceGear


Posts: 1821
Joined: Thu Dec 18, 2003 11:39 am
Location: Sourcegear
PostPosted: Mon Feb 16, 2004 3:43 pm
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.

Return to Knowledge Base (Vault)

Who is online

Users browsing this forum: No registered users and 2 guests

cron