Master Database

  • Cliff Jones

    SSChampion

    Points: 10517

    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.

  • Richard Warr

    SSCertifiable

    Points: 6957

    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.

    _____________________________________________________________________
    MCSA SQL Server 2012

  • Cliff Jones

    SSChampion

    Points: 10517

    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.

  • OzYbOi d(-_-)b

    Hall of Fame

    Points: 3994

    thanks - good question to round out the week!

  • Ken Wymore

    SSCoach

    Points: 16668

    Nice question about a basic topic. Thanks!

  • SQLRNNR

    SSC Guru

    Points: 281252

    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

  • SQLback

    SSCrazy

    Points: 2897

    Nice question. Thanks

  • pnewhart

    SSC Eights!

    Points: 953

    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. 🙂

  • SanjayAttray

    SSChampion

    Points: 13157

    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.

  • TomThomson

    SSC Guru

    Points: 104773

    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

  • BuntyBoy

    SSCommitted

    Points: 1876

    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]

  • khelloufsofiane 6183

    SSC Eights!

    Points: 862

    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.

  • CoolCodeShare

    SSCrazy

    Points: 2584

    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

  • msattaruddin

    SSC Rookie

    Points: 25

    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

  • msattaruddin

    SSC Rookie

    Points: 25

    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 34 total)

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