Solved

Change default directories - Management Studio Express 2005

Posted on 2007-11-29
3
969 Views
Last Modified: 2008-02-01
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
Comment
Question by:NeoTeq
3 Comments
 
LVL 1

Expert Comment

by:Alex342
ID: 20372142

 
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
 
LVL 25

Accepted Solution

by:
imitchie earned 500 total points
ID: 20372214
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
 
LVL 10

Author Comment

by:NeoTeq
ID: 20372320
Thanks!
0

Featured Post

Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Nowadays, some of developer are too much worried about data. Who is using data, who is updating it etc. etc. Because, data is more costlier in term of money and information. So security of data is focusing concern in days. Lets' understand the Au…
When you hear the word proxy, you may become apprehensive. This article will help you to understand Proxy and when it is useful. Let's talk Proxy for SQL Server. (Not in terms of Internet access.) Typically, you'll run into this type of problem w…
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.

863 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

24 Experts available now in Live!

Get 1:1 Help Now