Post reply

Moving system databases to a another folder

  • June 26, 2007 at 11:51 am

    #715314

    Just a tidbit of info... The path to the registry entry mentioned above is for "default" instances. For named instances use:

    [HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\\MSSQLServer\Parameters]

    Stop SQL Server,

    Move master(mdf+ldf),

    Change the above path,

    Start sqlserver with switches,

    detach other dbs,

    move other dbs,

    attach other dbs.

  • June 26, 2007 at 11:53 am

    #715315

    Sorry... Previous posting eliminated entries in the path...

    Between Microsoft SQL Server\ and MSSQLServer is the named instance.

    [HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\instance name\MSSQLServer\Parameters]

Viewing 2 posts - 16 through 16 (of 16 total)

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