>From now we're doing is to validate the database then recover the files. Is >there any way to prevent this scenario? with out using UPS?
No... corruption happens when power outages occur - there's nothing you can do about it up front besides a UPS. This seems like a trivial thing - a UPS is only a few hundred dollars. Compare that with the time spent recovering from the corruption.
By all means... buy a UPS!!!!
Wayne Myers, MCSD
Senior Consultant
Forte' Incorporated
"The only things you can take to heaven are those which you give away" Author Unknown