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 |
|
elwoos
Master Smack Fu Yak Hacker
2052 Posts |
 Posted - 2004-02-03 : 04:24:58
|
| eek! My Sql Server 7 has effectively just been switched off! Power failed UPS died, no access to comms room as I am not a network admin!! When power was returned and the machine rebooted it all seemed to work ok (I was suprised too) My question is, what if any checks etc can I run to ensure the integrity of the system and is there anything else I should be doing in these circumstances?Many many thankssteveSteve no function beer well without |
|
|
SamC
White Water Yakist
3467 Posts |
Posted - 2004-02-03 : 09:11:44
|
| You might try what I do when events like these occur... I run screaming with my hands in the air.There's also "DBCC CHECKDB". It isn't as much fun and lacks management visibility.Good luck.Sam |
 |
|
|
rihardh
Constraint Violating Yak Guru
307 Posts |
Posted - 2004-02-03 : 10:14:20
|
| Loud swearing and blaming the management for poor hardware in front of the CEO's office could be another option. But, on second thought, I'd stick to Sam's advice. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-02-03 : 12:34:21
|
| You should also check the SQL Server Error Log for errors and the application log in the Event Viewer.Tara |
|
|
|
elwoos
Master Smack Fu Yak Hacker
2052 Posts |
Posted - 2004-02-16 : 03:13:43
|
Thanks to all, especially Sam  steveSteve no function beer well without |
|
|
|
|
|
|
Check Please!