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

Neil Pike

March 4, 1999

1 Min Read
ITPro Today logo in a gray background | ITPro Today

A. It is kept in the SQLArg0 value inHKEY_LOCAL_MACHINESOFTWAREMicrosoftMSSQLServerMSSQLServerParameters.

The value has a form like "-dD:MSSQLDATAMASTER.DAT"

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

Sign up for the ITPro Today newsletter
Stay on top of the IT universe with commentary, news analysis, how-to's, and tips delivered to your inbox daily.

You May Also Like