May 19, 2003 at 6:20 am
Recently I had the following problem.
Some time ago I moved the master, msdb and model to another disk on an existing SQL2K SP3 installation.
Now recently because of a crash I needed to rebuild the master db on that system and as destination this utility proposed me always the first location of the master DB. I searched the complete registry and all text based files on the server but I couldn’t find where he could still find this original location.
Can some one tell me why rebuildm doesn’t propose the current master db location and where this utility finds the original location?
Thanks.
May 22, 2003 at 8:00 am
This was removed by the editor as SPAM
May 22, 2003 at 9:49 am
Search the registry for "master.mdf".
or HKLM\Software\Microsoft\Microsoft SQL Server\SQL2K\Parameters
SQL2k is the instance name.
This is actually a trick I found to move Master. Restore the correct master to ???.
STOP SSQL, change the RegData, restart and it points to the new one.
But a DANGEROUS trick, even with the standard "editing the registry ...."
KlK, MCSE
KlK
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply