Home Forums SQL Server 2008 SQL Server 2008 Administration Does the adrenaline rush ever subside when rebooting a DB server. RE: Does the adrenaline rush ever subside when rebooting a DB server.

  • February 27, 2013 at 10:04 pm

    #1591858

    CapnHector (2/27/2013)

    I work in a small shop as the accidental DBA and for the first time rebooted our production DB server after applying CU 9 to fix some issues we were having. It went fine but until the server booted up and sql started I had that adrenaline rush of what happens if ... Does that ever get better when you have to do something to a Major point of failure (We have a backup server but it would take several hours to get up and running again).

    This time every thing went fine and i had proper backups but it was still nerve racking.

    It's always a bit of a breath-holding moment but it looks like you took the right steps to keep it from being a poopin'-in-you-pants moment. 😉

    Just to be sure, you said you had the "proper bacckups". Does that include the C:Drive and something to recover the registry other than a system "checkpoint"?

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)