Link to home
Start Free TrialLog in
Avatar of NeoTeq
NeoTeq

asked on

Change default directories - Management Studio Express 2005

Is there a way for me to change some of the default directories Management Studio Express 2005 gives me? For example, I would like to change the default location from which to restore a database from the default "C:\Program Files\(...)\Backup\" to "D:\Backups\", or the restore option to  "D:\[databasename]\[databasename].mdf". Is there a location where I can edit these?
Avatar of Alex342
Alex342


 
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:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\MSSQLServer

with the name of "BackupDirectory" and the value of the directory path eg.:
Code:
C:\Program Files\Microsoft SQL Server\MSSQL\BACKUP
 
ASKER CERTIFIED SOLUTION
Avatar of imitchie
imitchie
Flag of New Zealand image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of NeoTeq

ASKER

Thanks!