Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
TimS
Posting Yak Master
198 Posts |
 Posted - 2005-08-16 : 19:28:17
|
| The local datacenter had a person cut the power to it after the UPS.In addition to DBCC CHECKDB, what should I check.SQL 2000 SP3 and SP4 servers running on WIN2003 RTM.Tim S |
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2005-08-16 : 20:44:46
|
| I would make sure that you have good backups. I would take a backup run DBCC checkdb and then maybe take another set of backups. I am paranoid like that.I would have your hardware people take a look at your raidsets to make sure that you don't have any RAIDs in a degraded status.you can also check SQL Server error logs and system/application event logs for anything out of the ordinary. I would do this after mnaking sure you have good backups and DBCC checkdb came back clean.-ec |
 |
|
|
Thrasymachus
Constraint Violating Yak Guru
483 Posts |
Posted - 2005-08-16 : 20:56:57
|
| better make sure those win2k servers are patched. Wolf Blitzer on CNN was in a tizzy when I got home because some slack tech guy had'nt patched his and they got hit by the new worm in town which turns off your server. Microsoft has a patch and the fix should be in the current virus definitions. Buddy of mine got hit by it yesterday.====================================================Regards,Sean RoussyThank you, drive through |
|
|
|
TimS
Posting Yak Master
198 Posts |
Posted - 2005-08-16 : 23:02:49
|
| Thanks for the help; I will check the event log tommorrow; I already did every thing else. Except backups which the network/system person has down according to the SQL error logs. Also, tell the network/system person to check the RAID for degraded status.Note: The network/system people just patched every thing last week so unless a patch was issued after patch tuesday we should be all patched.The policy here is not to apply SP1 on most WIN2003 servers. And, I don't trust SQL sp4 yet on the production running it only on test.Tim S |
|
|
|
|
|
|
POWER LOST what to check