SEO

#1 (**permalink**) 02-28-2008, 06:32 PM

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

#2 (**permalink**) 02-28-2008, 06:33 PM

The master, model, and tempdb databases cannot be detached/attached.

--
-- Anith
( Please reply to newsgroups only )

#3 (**permalink**) 02-28-2008, 06:33 PM

Hi

Check out http://support.microsoft.com/default...b;EN-US;304692

John

"Jagannathan Santhanam" <jags_32@yahoo.com> wrote in message
news:605df08e.0310271102.e5deab7@posting.google.co m...
> 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

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

How to detach System Databases...