Visit Counter

Sunday, February 26, 2017

Possible index corruption detected. run dbcc checkdb


I get occasional Event Log Errors stating "Possible index corruption detected. Run DBCC CHECKDB

Use database_name
GO
ALTER DATABASE database_name SET SINGLE_USER
GO
DBCC CHECKDB('database_name', REPAIR_REBUILD)
GO
to return to multi-user mode:

ALTER <database-name> SET MULTI_USER

Refer:
https://social.msdn.microsoft.com/Forums/sqlserver/en-US/fd80392c-fb4b-4743-955b-1cb1be5f7072/dbcc-checkdbdb-name-repairrebuild?forum=sqltools

No comments:

Post a Comment