Where is the pointer to master stored in SQL Server? How can I move the master database?

A. It is kept in the SQLArg0 value in HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\MSSQLServer\Parameters.

The value has a form like "-dD:\MSSQL\DATA\MASTER.DAT"

To move master just shutdown SQL Server, move the device using explorer/move, amend this registry parameter and then restart.


Hide comments

Comments

  • Allowed HTML tags: <em> <strong> <blockquote> <br> <p>

Plain text

  • No HTML tags allowed.
  • Web page addresses and e-mail addresses turn into links automatically.
  • Lines and paragraphs break automatically.
Publish