Post reply

Move Root Directory

  • January 18, 2013 at 8:41 am

    #269551

    Hi All,

    I have recently built our new production SQL Server and we have been using the D volume to store our root directories for all instances.

    In my haste i've noticed the route directory of one of the instances has been installed on a different drive by mistake and the instance is now in production.

    For the sake of housekeeping, i would like to move the root directory onto the D volume with the others but i don't want want to compromise the stability of the instance.

    I am assuming it is a litte more complicated then stopping the services, moving the folder, changing the root directory setting in the server option and then restarting the services.

    Does anyone have any experience of this kind of action? Any advice would be greatfully received.

    Thanks in advance.

    DBANewbie.

  • January 18, 2013 at 9:13 am

    #1578766

    I'm going through a similar situation - check out my thread - http://www.sqlservercentral.com/Forums/Topic1407363-1550-1.aspx#bm1408963

    In your situation, what do you mean by "root" directory? if there's just user DBs on the wrongfully placed drive, it's a simple matter of changing the location in the master database, physically moving the files, then restarting the server.

    However, if you have installed the SQL Server installation on this "other" drive, there's much more to it

    ______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience

  • January 18, 2013 at 9:34 am

    #1578771

    Thanks for the reply, a problem shared is a problem halved as they say.

    My database files are on a seperate volume, it is the install directory which is installed on the C drive that I need to move to the D drive.

    I have been through the registry and there are a number of places where this directory is stored so I would assume I would need to change each of those as well as making the change within Ssms.

    As it stands, I will just leave te install directory on the wrong volume and just deal with it unless someone can advise on the steps necessary.

    I'll read through your thread now.

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

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