View Single Post

   
  #1 (permalink)  
Old 02-28-2008, 07:32 PM
Jagannathan Santhanam
 
Posts: n/a
Default How to detach System Databases...

We have C:, D: and E: drives on our server box. C: drive is
partitioned and is big enough only to hold Operating system files. D:
and E: drives are what were supposed to be used by developers / dba's
to store / create SQL Server (system and user databases).

Well, some developers installed the entire SQL Server named instance
and their system and user defined databases on the C: drive. Is there
any way to move the system databases (master, msdb, distribution
etc.,) from the C: to the D: / E: drives?

Appreciate any feedback.

Thanks
Jagannathan Santhanam
Reply With Quote