Rebuilding The Master Database

  • Comments posted to this topic are about the item Rebuilding The Master Database

  • Nice question, thanks.

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • Good question - something we should all know

    -------------------------------Posting Data Etiquette - Jeff Moden [/url]Smart way to ask a question
    There are naive questions, tedious questions, ill-phrased questions, questions put after inadequate self-criticism. But every question is a cry to understand (the world). There is no such thing as a dumb question. ― Carl Sagan
    I would never join a club that would allow me as a member - Groucho Marx

  • Good question. Thanks.

    M&M

  • Useful question.

  • Good question.

    I guess I'm glad that I don't know this answer from experience, just from reading.

    Tom

  • This was removed by the editor as SPAM

  • Good question,

    I had it right, then I thought to double check myself and searched out rebuildm.exe

    didn't realize I hit the Msdn article for SQL 2000 and picked the wrong answer (shockedly because I thought that setup.exe was the way to go)... ah well... live and learn.



    --Mark Tassin
    MCITP - SQL Server DBA
    Proud member of the Anti-RBAR alliance.
    For help with Performance click this link[/url]
    For tips on how to post your problems[/url]

  • Good question. I thought I knew the correct answer and took a shot at it. Glad I got my point.

    http://brittcluff.blogspot.com/

  • very good question!


    [font="Times New Roman"]rfr.ferrari[/font]
    DBA - SQL Server 2008
    MCITP | MCTS

    remember is live or suffer twice!
    the period you fastest growing is the most difficult period of your life!
  • Thanks & Good question.

    L' Eomot Inversé (10/4/2011)


    Good question.

    I guess I'm glad that I don't know this answer from experience, just from reading.

    My thoughts exactly Tom!

  • OzYbOi d(-_-)b (10/4/2011)


    Thanks & Good question.

    L' Eomot Inversé (10/4/2011)


    Good question.

    I guess I'm glad that I don't know this answer from experience, just from reading.

    My thoughts exactly Tom!

    I wish it was so for me too! I had to rebuild the master database for a collation change and it's a *PAIN*, especially on big SQL Server 2005 clusters. The setup process has to start on each passive node before you can rebuild the master database and (multiple nodes) = (multiple possible reasons for a failure).

    Everything document here[/url], if you're interested in the story and the workaround.

    -- Gianluca Sartori

  • Nice question. Good to know information. Hopefully I will never have to actually use it!

  • Good info to know. I have had to use rebuildm in past jobs and knew it had been replaced. Also figured that if the master was corrupt that the DAC wouldn't probably work. I echo other's thoughts that I hope I don't have to ever use it in production, but I think I'll mess around with it in a sandbox as it is good to know how to use it.

  • Thanks for the 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

Viewing 15 posts - 1 through 15 (of 17 total)

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