Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 


 
     
Recent Posts
   
Popular Topics
Home   
Search
    Members    Calendar    Who's On

Home » SQL Server 2008 » SQL Server 2008 Administration » Does the adrenaline rush ever subside when...
Add to briefcase

Does the adrenaline rush ever subside when rebooting a DB server. Expand / Collapse
Rate Topic
Display Mode
Topic Options
Author
Message
CapnHector
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: 2 days ago @ 10:07 AM
Points: 935, Visits: 1,709
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
Minaz
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: Sunday, April 21, 2013 10:57 PM
Points: 535, Visits: 1,423
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
Jeff Moden
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 @ 12:30 PM
Points: 32,893, Visits: 26,770
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."

For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
Post #1424893
tmeyer1969 31535
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: Thursday, February 28, 2013 9:00 AM
Points: 1, Visits: 0
On the plus side, after doing it 1000 times, you just won't care
Post #1425085
homebrew01
Posted Thursday, February 28, 2013 9:43 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: 2 days ago @ 11:37 AM
Points: 2,551, Visits: 7,201
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
MyDoggieJessie
Posted Thursday, February 28, 2013 10:47 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: 2 days ago @ 8:50 AM
Points: 2,035, Visits: 3,759
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
CapnHector
Posted Monday, March 04, 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: 2 days ago @ 10:07 AM
Points: 935, Visits: 1,709
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
dan-572483
Posted Tuesday, March 05, 2013 10:17 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: 2 days ago @ 11:09 PM
Points: 328, Visits: 939
If you've experienced a production clustered instance getting trashed by a botched Service Pack install, then no.
Post #1426929
Jay Beta
Posted Thursday, March 07, 2013 10:22 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Friday, May 03, 2013 7:16 AM
Points: 12, Visits: 57
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

 
 
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved. Privacy Policy. Terms of Use. Report Abuse.