Hi
We have constant issues that our database going frequently in SUSPECT MODE
The only way to fix that is
ALTER DATABASE DB SET EMERGENCY;
GO
ALTER DATABASE DB SET SINGLE_USER;
GO
DBCC CHECKDB (DB, REPAIR_ALLOW_DATA_LOSS) WITH NO_INFOMSGS, ALL_ERRORMSGS;
GO
ALTER DATABASE DB SET MULTI_USER;
GO
But since we have those probelms more and more, I wanted to proactivly cut those issues.
HOw can we prevent that so DB will not go into suspect?
I've logs from yesterday crash, if someone can give me some advice that would be great
Thanks
Andrew
Go to the complete details ...