Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 995
  • Last Modified:

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?
0
NeoTeq
Asked:
NeoTeq
1 Solution
 
Alex342Commented:

 
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
 
0
 
imitchieCommented:
It is best set at install time. You can run into multiple problems if you choose to change it from the registry. This article explains the default paths, how to set them and some reasons for why not to change them willy nilly.

http://msdn2.microsoft.com/en-us/library/ms143547.aspx
0
 
NeoTeqAuthor Commented:
Thanks!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

A proven path to a career in data science

At Springboard, we know how to get you a job in data science. With Springboard’s Data Science Career Track, you’ll master data science  with a curriculum built by industry experts. You’ll work on real projects, and get 1-on-1 mentorship from a data scientist.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now