Solved

Change default directories - Management Studio Express 2005

Posted on 2007-11-29
3
976 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

Edgartown IT Case Study

Learn about Edgartown's quest to ensure the safety and security of the entire town's employee and citizen data. Read the case study!

Question has a verified solution.

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

Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
This article shows gives you an overview on SQL Server 2016 row level security. You will also get to know the usages of row-level-security and how it works
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.
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed

733 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