February 8, 2010 at 8:52 am
We had our data center power failure this morning. I am just wondering what would be the sequence of steps that we could follow after the center is up. Considering we have identified all the servers/databases that are not accessible. I have jotted down couple of steps that we can follow.
1. Make sure all the installed services on the server are up and running
2. Make sure that all the databases are in consistent state, Check whether all the databases that got affected are in ONLINE status.
3. Run consistency and integrity checks on all the affected databases.
4. Check the SQL Server error logs
5. Check the Windows application event logs for any errors.
Considering SQL Server does not have many tier 1 applications. What else could you recommend?
Thanks all
Edited @ 4th point
February 8, 2010 at 9:00 am
That's a pretty good list. I might scan with SMS or Ops Center if you have them to see what's down.
You might build a list of SQL Servers that need to be checked as you do this. You can automate these checks, or a lot of them, by using PowerShell/VBScript in the future.
Follow me on Twitter: http://www.twitter.com/way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
February 8, 2010 at 9:56 am
check the job history.In case any of the scheduled jobs failed during this power failure and you can run them again.
February 10, 2010 at 4:33 pm
Make sure you also check all the backup files, they may be corrupted some times. Run full backup of all servers once they are back online.
EnjoY!
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply