Post reply

Master DB Location Inconsistent

  • April 9, 2004 at 6:18 am

    #101953

    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

    #502282

    Have you closed and reopended QA since you moved master?


    Shamless self promotion - read my blog http://sirsql.net

  • April 9, 2004 at 10:09 am

    #502316

    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.

  • April 9, 2004 at 10:54 pm

    #502362

    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 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply