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
GO
DBCC CHECKDB('database_name', REPAIR_REBUILD)
GO
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