April 9, 2004 at 6:18 am
I wanted to move the location of the Master DB, so I followed Microsoft Note http://support.microsoft.com/default.aspx?kbid=224071.
As referenced in the note, I set the -d startup parameter to the desired location. Everything is working OK.
Enterprise Manager shows the correct location, but when I run the following query it shows the old location.
select name, filename from sysdatabases
where name = 'MASTER'
Any ideas?
Thanks,
Steve
April 9, 2004 at 6:58 am
Have you closed and reopended QA since you moved master?
April 9, 2004 at 10:09 am
If you didn't detach, reattach then I'm not surprised. the entry in the table is static, probably (my guess) changed only when attach detach. The parameter on startup is an override.
Follow me on Twitter: http://www.twitter.com/way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
April 9, 2004 at 10:54 pm
I have stopped and restarted instance. But will do again to be sure.
I will attempt to detach and attach master. Did not think you could do that though. Per the MS note referenced, MSDB and Model could only be dettached with a "-T3608" referenced in the startup paramter.
If you attempt to detach master, you will most likely get a
Server: Msg 7940, Level 16, State 1, Line 1
System databases master, model, msdb, and tempdb cannot be detached.
Stranger things have happened, I will attempt and repost.
Thanks for Input.
Steve
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply