Post reply

Master Database

  • August 19, 2011 at 8:14 am

    #1370758

    Mattrick (8/19/2011)

    Thank you for the question.

    At the risk of sounding cliche, I am pretty surprised that this many people are getting this wrong. I am especially surprised about the number of people who chose "SQL Server cannot start if the master database is unavailable". I am no master or expert, so I won't rant and rave about it, but I do hope the people who answered it incorrectly took the time to look into why their answer was incorrect. Knowing that SQL Server cannot start due to an unavailable master database is a pretty important thing to know.

    Thanks again,

    Matt

    I can only assume that it's easy to trip on the double negatives.

  • August 19, 2011 at 8:25 am

    #1370766

    Cliff Jones (8/19/2011)

    I can only assume that it's easy to trip on the double negatives.

    ...or that not everybody here is a DBA.

  • August 19, 2011 at 8:40 am

    #1370779

    Richard Warr (8/19/2011)

    Cliff Jones (8/19/2011)

    I can only assume that it's easy to trip on the double negatives.

    ...or that not everybody here is a DBA.

    Yes, that is the other possibility. I had to read that particular statment a couple of times before I came to the conclusion that is was not NOT True.

  • August 19, 2011 at 9:03 am

    #1370809

    thanks - good question to round out the week!

  • August 19, 2011 at 9:50 am

    #1370852

    Nice question about a basic topic. Thanks!

  • August 19, 2011 at 10:06 am

    #1370872

    nice question

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • August 19, 2011 at 12:14 pm

    #1370931

    Nice question. Thanks

  • August 19, 2011 at 2:32 pm

    #1370978

    Hmm, I obviously didn't give this enough thought on a late Friday afternoon (in my time zone). I went with the mirroring selection. I eliminated the all but the correct answer and the one regarding mirroring and guestimated the wrong way. 🙂

  • August 19, 2011 at 9:32 pm

    #1371010

    Easy and straight question. But still wondering, why would any one want to change the owner of master database?

    Hmmm......may be possibilities are endless.

    SQL DBA.

  • August 20, 2011 at 2:40 am

    #1371020

    Good clear question.

    Too early in the morning though - after a late Friday night I shouldn't try to think properly before breakfast has restored normal brain function.

    Tom

  • August 20, 2011 at 11:42 am

    #1371077

    good question to test the basics 🙂

    ===========================================
    Better try and fail than not to try at all...

    Database Best Practices[/url]

    SQL Server Best Practices[/url]

  • August 21, 2011 at 1:55 am

    #1371128

    Hello,

    My answer was "SQL Server cannot start if the master database is unavailable"

    I think that is correct, isn't it?

    see this link please

    http://msdn.microsoft.com/en-us/library/ms187837.aspx

    Thanks for all.

  • August 21, 2011 at 7:18 am

    #1371154

    Hi Folks,

    Thanks for your nice comments.

    Hmmm, I believe some of us didn't read question thoughtfully. anyways... next time!!

    Have fun and Happy Janmashtmi (birth day of Lord Krishna) 🙂

    Regards,

    Sudhir

  • August 24, 2011 at 3:10 am

    #1372419

    Yes Sudhir is correct.

    I suggest to refer below url which indicates a note:

    "You cannot mirror the master, msdb, tempdb, or model databases."

    URL http://msdn.microsoft.com/en-us/library/ms189852.aspx

  • August 24, 2011 at 3:15 am

    #1372425

    I suggest to refer below url which indicates a note:

    "You cannot mirror the master, msdb, tempdb, or model databases."

    URL http://msdn.microsoft.com/en-us/library/ms189852.aspx

    Right answer point in quiz to "Master" owner can't change and it is owned by dbo. Since both are correct answers for this question

    1. Can't mirror master db

    2. master db owns by dbo.

Viewing 15 posts - 16 through 30 (of 33 total)

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