November 10, 2002 at 12:00 am
Comments posted to this topic are about the content posted at http://www.sqlservercentral.com/columnists/sjones/moveyourmaster.asp
November 10, 2002 at 11:36 am
Excellent Steve,This process is really simple.Next time when I need to move the master database I am going to take this approch.
November 11, 2002 at 9:25 am
Thanks. It is simple, but you might end up digging around and no one wants to do that in a pressure situation.
Glad you like it and hopefully this is an easy reference for everyone.
Steve Jones
November 18, 2002 at 9:30 pm
Excellent!...but I'm just wondering what are the benefits of moving master db, tempdb, msdb (SQL system DB) from its default location? Is there anything deal with performance issue or something else?
Hendry
November 19, 2002 at 9:02 am
Could be performance, mostly for tempdb. Personally, it's a standards thing. We move all the data to a drive and logs to another. May further separate out, but we have master on a standard drive at work.
Steve Jones
February 26, 2003 at 1:29 pm
I had trouble with this. Luckily it was on a non-production box. I mistakenly typed I for L in the path for the log file in the start up parameters in Enterprise Manager and of course SQL would not start. With no way to get back into SQL to change my typo, I went into the registry HKey Local Machine|Software|Microsoft|MSSQLServer|MSSQLServer|Parameters and change the path there. Then the weirdest thing happened. The registry would not accept the change. It looked like I was able to change the I to an L but then when I would try to start SQL the registry changed itself back to the incorrect path. I fooled around with it for several hours, deleting the key, recreating the key etc. and then gave up when I could not get it to keep the change I made. Ended up reinstalled SQL with the master where I wanted it. Interestingly if you type an uppercase I or lowercase l in the registry you cannot physically see the difference. I have never seen the registry (Win2000) act like this. I suspect this value is held in another place that I am not aware of and overrided this registry key.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply