Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
NewFrontier
Starting Member
3 Posts |
 Posted - 2006-11-15 : 11:31:19
|
This is my first time using sql server 2005 and I was wondering can you change the default drive to create databases on. My exec is on the C drive but I want all my db's on the e drive. How can I do that?Thanks in advance. |
|
|
snSQL
Master Smack Fu Yak Hacker
1837 Posts |
Posted - 2006-11-15 : 15:03:57
|
| Right click your server in SSMS and select Properties. Select the Database Settings page and on that page you'll find Database default locations.Note that you can specify a different path for every database file and log file when you create the database or when you alter the database, you don't have to put all the files in the location specified by the default location. |
 |
|
|
|
|
|
SQL Server 2005 config