Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Does the adrenaline rush ever subside when rebooting a DB server. Expand / Collapse
Author
Message
Posted Wednesday, February 27, 2013 2:04 PM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Sunday, July 20, 2014 7:16 AM
Points: 945, Visits: 1,769
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.



For faster help in answering any problems Please read How to post data/code on a forum to get the best help - Jeff Moden 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

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

Jeremy Oursler
Post #1424742
Posted Wednesday, February 27, 2013 9:10 PM


Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Tuesday, March 11, 2014 3:34 AM
Points: 549, Visits: 1,554
Hey CapnHector,

Do agree with you , as a DBA, we all have the same nervous system. Almost each time I will be biting my nails until the server comes up.

That is in our nature to rush the adrenaline


"More Green More Oxygen !! Plant a tree today"
Post #1424877
Posted Wednesday, February 27, 2013 10:04 PM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: General Forum Members
Last Login: Today @ 11:31 AM
Points: 36,714, Visits: 31,164
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."

(play on words) "Just because you CAN do something in T-SQL, doesn't mean you SHOULDN'T." --22 Aug 2013

Helpful Links:
How to post code problems
How to post performance problems
Post #1424893
Posted Thursday, February 28, 2013 9:04 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Yesterday @ 9:21 AM
Points: 1, Visits: 40
On the plus side, after doing it 1000 times, you just won't care
Post #1425085
Posted Thursday, February 28, 2013 9:43 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: 2 days ago @ 9:19 AM
Points: 2,826, Visits: 8,462
tmeyer1969 31535 (2/28/2013)
On the plus side, after doing it 1000 times, you just won't care


True. We had a PCI requirement to apply patches & reboot 15 servers every month Add to that some had encrypted drives that had to be remounted each time.... got pretty tiresome & annoying.



Post #1425133
Posted Thursday, February 28, 2013 10:47 AM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Monday, July 14, 2014 2:06 PM
Points: 3,860, Visits: 7,130
As long as you're the person who's responsible for the outcome, I don't think it ever goes away.

Recently, in our busiest Production environment, I had to relocate several large (+1TB) DB's to a new SAN. While the process is quite simple (updating the files to point to their new respective locations, taking the DB's offline, physically copying the files to their new homes, then bringing them back online...) the seconds it took for each database to come back online felt like hours! The "what if..." questions that go through your head never stop...



______________________________________________________________________________
"Never argue with an idiot; They'll drag you down to their level and beat you with experience"
Post #1425188
Posted Monday, March 4, 2013 3:07 PM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Sunday, July 20, 2014 7:16 AM
Points: 945, Visits: 1,769
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 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

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

Jeremy Oursler
Post #1426482
Posted Tuesday, March 5, 2013 10:17 AM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: 2 days ago @ 10:48 AM
Points: 526, Visits: 1,552
If you've experienced a production clustered instance getting trashed by a botched Service Pack install, then no.
Post #1426929
Posted Thursday, March 7, 2013 10:22 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Yesterday @ 8:24 AM
Points: 12, Visits: 79
I have found a direct correlation between my experience levels and the amount of anxiety I experience. As long as I feel good about my ability to recover, the anxiety is relatively minor.
Post #1428119
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse