nilmov (5/15/2009)
As you said that the DB goes to suspect now and then and also the h/w check came clean.
Only thing I can think of right now is disk controller.
Refer this KB which briefs about the impact of disk controller caching on SQL Server .
http://support.microsoft.com/kb/86903%5B/quote%5D
Thanks for the link nilmov. I have read the Article and noted the contents.
In the article it is said that,
Even if the server uses a UPS, this does not guarantee the security of the cached writes..
And we have observed, many times Power and UPS failure in the branches, Is it better if I disable Disk Caching Option?