Power Outage

Question

Power Outage

HBK_4700

SSCrazy Eights

Points: 8932
More actions
January 19, 2010 at 9:01 am

#141820

We had power outage for production server in our datacenter. it seems for 1 hour and now server is up and running fine.
What are things I need to check and make sure that everything is fine?

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

The_SQL_DBA SSChampion Points: 10494 More actions · Answer 1

Make sure all the services are running properly. Also a DBCC check on the important databases would be good. Suggest reading this article

HTH...

The_SQL_DBA
MCTS

"Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives."

HBK_4700 SSCrazy Eights Points: 8932 More actions · Answer 2

The_SQL_DBA (1/19/2010)
Make sure all the services are running properly. Also a DBCC check on the important databases would be good. Suggest reading this article
HTH...

Thanks for the reply..everything is good now

We don't have any monitoring tool now.

I would like to know whether is there any paging systems for server monitoring?

Jeff Moden SSC Guru Points: 1000539 More actions · Answer 3

I'd recommend spending a some bucks on an uninteruptable power supply for the server that has the ability to do a soft shutdown after xx minutes of power outage. Depending on the make and model, some will also page you provided it's hooked up to a phone line.

--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)
Intro to Tally Tables and Functions

HBK_4700 SSCrazy Eights Points: 8932 More actions · Answer 4

Thanks to all.

We had a 50 min power outage. We did not get any outage notification from hosting company in time. Our websites are down, no rdp to servers during that time.

What would be the best escalation process, rules etc