April 5, 2017 at 7:20 am
EXEC sp_MSforeachDB 'DBCC CHECKDB (?) WITH ALL_ERRORMSGS,EXTENDED_LOGICAL_CHECKS, DATA_PURITY'
I am currently having an issue withconsistency error message when running the error massages:
EXEC sp_MSforeachDB 'DBCC CHECKDB (?) WITHALL_ERRORMSGS,EXTENDED_LOGICAL_CHECKS, DATA_PURITY'
To resolve the issue, a repair on the database was performed then the followingDBCC script was run:
DBCCCHECKDB (databasename) and is completed successfully.
The issue now is, thefollowing day when the data integrity job was run, the issue reoccurred:
Error message:
The spatial index,XML index or indexed view 'sys.extended_index_0000000 (object ID ) does not containall rows that the view definition produces.
CHECKDB found 0allocation errors and 4 consistency errors in database 'databasename'.
repair_rebuild is theminimum repair level for the errors found by DBCC CHECKDB (databasename).
Thank you in advance
April 9, 2017 at 5:46 pm
http://www.sqlservergeeks.com/repair-the-database-using-dbcc-checkdb/
you will need to run a repair rebuild command. see article
MCSE SQL Server 2012\2014\2016
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply