Post reply

How to move system databases to diffrent drive?

  • June 20, 2008 at 7:06 am

    #122833

    hello,

    I Installed sql server 2005.The system databases are in C drive now. But I need to move system databases to D drive.

    What will be the safe way to do this?

    Thanks

  • June 20, 2008 at 7:14 am

    #831732

    Yes you can move the master/tempdb/model/msdb to diff drives. but do not try to move the resource database.

    Again, leave the resource and master Databases at the same location. they both are required to be at the same location to function properly.

    Rest you can make a move:

    http://msdn.microsoft.com/en-us/library/ms345408.aspx

    Rest Follow the sequence of Bringing the DB's Online.

    My Suggestion would be to Just move the MSDB/TEMPDB, as these might Grow really Fast... while the rest of the system DBs are Harmless.

    Maninder
    www.dbanation.com

  • June 20, 2008 at 7:25 am

    #831746

    Mani beat me to the link but in general, never put databases on your c: partition if you can avoid it. If possible, move tempb to it's own physical drive(s). If you do maintenance (index rebuilds especially) or run large inserts/updates/deletes, count on TEMPDB needing to be large enough to accomodate it (read, potentially "Grow really Fast... "). Lastly, read the link thoroughly. Mani stated "but do not try to move the resource database." but if you are moving master, you MUST move the resource database to the same location (I believe that was the point Mani was trying to express).

    -- You can't be late until you show up.

  • June 20, 2008 at 7:28 am

    #831749

    Hello Mani,

    can I detach the master database and attach in d drive?

    is this works or any other method is there?

  • June 20, 2008 at 7:31 am

    #831752

    The Resource Database depends on teh master Database.. Check the Link.. it has more info, then i can share here with you...

    So keep master and resource DB's Together.. whereever they go...

    Maninder
    www.dbanation.com

  • June 20, 2008 at 7:39 am

    #831759

    Here is an article from this site. May provide a little more insight.

    http://www.sqlservercentral.com/articles/Administration/2605/

    -- You can't be late until you show up.

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply