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 |
|
Gyto
Posting Yak Master
144 Posts |
 Posted - 2009-07-22 : 10:31:28
|
| Hi there,We have a new SQL 2005 server and I have been asked if I can move the system databases from the C:\ drive and put their data and log files on seperate drives, as with all of our other databases. I am aware of the benefits of having these files seperate but was wondering if would make much difference for the system databases as they are largely not transactional? Also, correct me if I'm wrong but I'm guessing you can't just detatch them and reattach them as with normal databases?Is it a risky process to move them and are the benefits worthwhile in the long run or are they fine as they are?Thanks,Matt |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2009-07-22 : 10:55:12
|
| I usually leave them on the C: drive, ecept for tempdb and sometimes msdb.Anyway, see here: http://support.microsoft.com/kb/224071and here: http://msdn.microsoft.com/en-us/library/ms345408.aspx |
 |
|
|
Gyto
Posting Yak Master
144 Posts |
Posted - 2009-07-23 : 05:11:41
|
| Great, thanks. |
|
|
|
|
|
|
Moving the system databases