Changing the Path for the Master Database

  • Sadan Kumar

    SSC Enthusiast

    Points: 182

    Comments posted to this topic are about the item Changing the Path for the Master Database

    Sadan Kumar Budde

  • HappyGeek

    SSCoach

    Points: 18684

    Very well written article. However you have not mentioned Microsoft's recommendation to alter the registry setting at: HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\instance_ID\Setup, where instance_id is the installed instance you are moving and to change the SQLDataRoot value to the new path, otherwise updates and patches may fail.

    ...

  • anthony.green

    SSC Guru

    Points: 112481

    HappyGeek - Thursday, December 14, 2017 12:59 AM

    Very well written article. However you have not mentioned Microsoft's recommendation to alter the registry setting at: HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\instance_ID\Setup, where instance_id is the installed instance you are moving and to change the SQLDataRoot value to the new path, otherwise updates and patches may fail.

    Do you have a link to said article?  Never done this when moving the master DB as not modifying the binary location, only where the master mdf and ldf live which is totally configurable through SQL Config Manager as Sadan's article shows.

  • HappyGeek

    SSCoach

    Points: 18684

    anthony.green - Thursday, December 14, 2017 1:06 AM

    HappyGeek - Thursday, December 14, 2017 12:59 AM

    Very well written article. However you have not mentioned Microsoft's recommendation to alter the registry setting at: HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\instance_ID\Setup, where instance_id is the installed instance you are moving and to change the SQLDataRoot value to the new path, otherwise updates and patches may fail.

    Do you have a link to said article?  Never done this when moving the master DB as not modifying the binary location, only where the master mdf and ldf live which is totally configurable through SQL Config Manager as Sadan's article shows.

    Sure, try this Microsoft article it is mentioned in paragraph 10 under Moving the master Database.

    ...

  • anthony.green

    SSC Guru

    Points: 112481

    HappyGeek - Thursday, December 14, 2017 1:20 AM

    anthony.green - Thursday, December 14, 2017 1:06 AM

    HappyGeek - Thursday, December 14, 2017 12:59 AM

    Very well written article. However you have not mentioned Microsoft's recommendation to alter the registry setting at: HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\instance_ID\Setup, where instance_id is the installed instance you are moving and to change the SQLDataRoot value to the new path, otherwise updates and patches may fail.

    Do you have a link to said article?  Never done this when moving the master DB as not modifying the binary location, only where the master mdf and ldf live which is totally configurable through SQL Config Manager as Sadan's article shows.

    Sure, try this Microsoft article it is mentioned in paragraph 10 under Moving the master Database.

    Thanks, and the only reason I didn't know that is they only added that point 10 to the 2016 documentation, the 2014, 2012 docs don't mention it, thanks for the updated info.
    https://technet.microsoft.com/en-us/library/ms345408(v=sql.120).aspx
    https://technet.microsoft.com/en-us/library/ms345408(v=sql.110).aspx

  • thierry.vandurme

    Hall of Fame

    Points: 3220

    Thanks for sharing. 
    You might also make a note about permissions. If the service account doesn't have appropriate permissions on the new path then SQL won't start.
    I'd also stress the fact that there is no space between the parameters (-d etc... )and its value (C:\...). I assume lots of people don't notice that and it can be a pain to troubleshoot
    Best regards
    Thierry

  • richlion2

    SSCrazy

    Points: 2479

    Sorry, I found the answer to my question, ignore this.

  • HappyGeek

    SSCoach

    Points: 18684

    richlion2 - Wednesday, December 20, 2017 5:01 AM

    Sorry, I found the answer to my question, ignore this.

    What was the question and answer? Someone may want to know and benefit.

    ...

  • Sadan Kumar

    SSC Enthusiast

    Points: 182

    Sure

    Sadan Kumar Budde

Viewing 9 posts - 1 through 9 (of 9 total)

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