No Idea. Actually my application uses 5 databases, for past 2-3 months I have observed minimum 3-4 times database in suspect mode in each branch, and corrupting database in not consistent with database.

What I mean to say is, any one of 5 database required for my application goes in suspect mode. In some instance even distribution database also I faced this problem. So I am not able figure out. Next time I will check each and every minute point and post here.

For so many days I was recovering the suspected database using

use master

go

sp_configure 'allow updates', 1

reconfigure with override

go

DBCC REBUILD_LOG( 'db_name', 'full name to new log file')

Use master

go

sp_configure 'allow updates', 0

Go

It is my mistake that I never tried to find the root cause for this problem.

Now it is frustrating