SQL Server Performance Forum – Threads Archive
Wht r the things to chk for/do when a srvr is downHello 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
You can check sql server error log and find what was the reason.
SQL-Server-Performance.com All in Love is Fair
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.
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
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.