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.

  • March 4, 2013 at 3:07 pm

    #1593189

    Jeff Moden (2/27/2013)

    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"?

    Proper backups means any thing i needed to bring the backup server online if i needed to or recover from a corrupt system database if it was just the service that failed. (backups of every database and all files for the application not in the DB were on an external drive ready to unhook and hook up to our backup server since the jobs that do that nightly had not run yet).

    Also any one who calls a system checkpoint a backup should not be a sysadmin. We do have an image of shortly before we went live of the C: drive but bringing the backup online is quicker than re imaging the drive. Since its been in production the only modification has been CU9.

    Thanks to every one else about there experience and I am looking forward to the next time i get that feeling.

    For faster help in answering any problems Please read How to post data/code on a forum to get the best help - Jeff Moden[/url] for the best way to ask your question.

    For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]

    Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
    Jeff Moden's Cross tab and Pivots Part 1[/url]
    Jeff Moden's Cross tab and Pivots Part 2[/url]