Wht r the things to chk for/do when a srvr is down | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Wht r the things to chk for/do when a srvr is down

Hello DBA’s What are the things to check for immediately when we happen to know that a server is down and not running. What are the steps to be taken to bring it back? Thanks
Satya
You can check sql server error log and find what was the reason.
Luis Martin
Moderator
SQL-Server-Performance.com All in Love is Fair
Stevie Wonder
All postings are provided “AS IS” with no warranties for accuracy.
Along with sql error log… check system log/application log because if the failure reason is other than sql it will not write to sql log … If it is cluster check the cluster.log too… MohammedU.
Moderator
SQL-Server-Performance.com
On above all make sure to have complete backups for user and system databases, where you can get back the server online. Make sure to test this disaster recovery procedures, as referred in this website and I have posted such link somewhere here. Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing. The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.
]]>