Power Outage / SQL

[R7Dave]

Hello

I have questions about SQL Server and power outages.

Is it better to leave SQL Server up when power is lost OR take the chance and shut it down at the risk of power being lost while it is still coming down.

Also - what happens to SQL Server if our SAN is shut down first?

Is there a difference in the way power outages are handled between SQL 2000, 2005, 2008?

The situation was we lost street power momentarily, had 45 minutes of UPS and one of our 2 generators was down (it takes 2 generators to run our data center) - there was no power loss but now we need to document what our best option is for the scenario of running out of power completely.

Also, I'm currently using RDP to log into each PC to stop the service - are there better suggestions?

Thanks in advance
Dave

 

[djj55]

IMHO, I would think you would want to gracefully down your servers during the 45 minutes on UPS (no generator scenario). You may need to bring them back up immediately but at least they are downed gracefully.

djj
The Lord is my shepherd (Psalm 23) - I need someone to lead me!

 

[needcoffee]

You need to shut SQL down if your database and log files reside on the SAN before the SAN is shutdown. Your shutdown time may vary depending on your log files last checkpoint and your activity level on the SQL server. If you do not shut down gracefully you take a higher risk of corruption.

Use the following to shut down the service on a remote computer if you are authenticated to same domain already and have the required priveledges:

SC \\ServerName stop ServiceName