Post reply

Moving system databases

  • February 5, 2013 at 3:24 pm

    #273797

    Hello.

    We currently hold the Master, model and msdb databases on the C drive. This drive is currently configured as RAID 1. It is approx a 180GB disc with approx 70Gb of free space.

    I am considering moving the Master db from the c drive onto its own LUN along with the other system databases.

    Can anybody offer any advice on wether this is a good idea or is it likely to cause more trouble ? Also I am presuming this type of operation needs to be done out of ours ?

    Any advice, links, on how to acomaccomplishse tasks would be appreciated.

    Thanks

    Steven

  • February 5, 2013 at 3:26 pm

    #1584636

    This is considered a best practice - to move system databases off of the c drive. I move all of my system databases to a different volume when possible.

    Here is an article on how to do it.

    http://msdn.microsoft.com/en-us/library/ms345408(v=sql.105).aspx

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • February 9, 2013 at 1:32 am

    #1586208

    thanks very much for this info.:-)

  • February 9, 2013 at 12:07 pm

    #1586246

    make sure you follow the sql2005 version of those instructions. Its vital you keep the resource database with the master database in SQL2005.

    This definitely needs to be done out of hours.

    ---------------------------------------------------------------------

Viewing 4 posts - 1 through 3 (of 3 total)

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