• 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?