in sql server (re)start where does it find the location of Master.mdf file .
In Oracle, there is control file where the location of *.dbf file is stored and Instance find the location of dbf file from that location
In sql server where it finds the location of Databases as master, msdb etc..
The location is set duing Server installation.
That information is stored in the registry. It can also be supplied as a command line start up parameter [ -dMasterFilePath ].
The registry location 'should' be:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\MSSQLServer\Parameters
No comments:
Post a Comment