Results 1 to 6 of 6
  1. #1
    Join Date
    Jul 2002
    Posts
    32

    Unanswered: Disaster - Recovery Order of events

    we are trying to simulate a disater recovery of our SQL2000 and SQL2005 development servers. Which is the order in which we should restore the DBs. I am talking specifically of MSDB, master and user DBs; should we restore user DBs before master and MSDB?

    Thanks,

    Carlos

  2. #2
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,800
    Provided Answers: 11
    Generally, you restore master first, then model(if you made any changes to it), and msdb. After that, all the user databases should be restored. THis goes for SQL 2000 and SQL 2005.

  3. #3
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    Generally I have a standby box
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  4. #4
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,800
    Provided Answers: 11
    lucky little %^*)

  5. #5
    Join Date
    Dec 2002
    Posts
    1,245
    Quote Originally Posted by MCrowley
    lucky little %^*)
    He didn't say WHAT kind of box. It's actually a box of 64 crayola crayons.

    Regards,

    hmscott
    Have you hugged your backup today?

  6. #6
    Join Date
    Nov 2004
    Location
    on the wrong server
    Posts
    8,835
    Provided Answers: 6
    i thought the first thing to do was to start blaming other people. maybe followed by some frantic yelling all around the office.

    maybe Brett has a squeezebox. But wait, if he has a squeezebox who doesn't sleep at night? I am confused. Back to writing code.
    “If one brings so much courage to this world the world has to kill them or break them, so of course it kills them. The world breaks every one and afterward many are strong at the broken places. But those that will not break it kills. It kills the very good and the very gentle and the very brave impartially. If you are none of these you can be sure it will kill you too but there will be no special hurry.” Earnest Hemingway, A Farewell To Arms.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •