I ran - DBCC CHECKDB WITH NO_INFOMSGS, and got error message.
CHECKDB found 0 allocation errors and 10 consistency errors not associated with any single object.
CHECKDB found 0 allocation errors and 10 consistency errors in database 'databasename'.
I set up database in single user mode, and did -
DBCC CHECKDB('databasename', REPAIR_REBUILD)
But still got same issue. Then I ran following Repair_allow_data_loss command. Sorry, still got the same issue.
DBCC CHECKDB (databasename, REPAIR_ALLOW_DATA_LOSS) WITH NO_INFOMSGS;
How to fix it?