Sim4977

Applying the fix in CU2 or latest service pack will prevent any future occurrence of the error. However, applying the fix will not repair the metadata that is already in an inconsistent state. To correct the inconsistent state, contact Microsoft SQL Server customer support. The issue was first fixed in the following cumulative update of SQL Server. Also i share a link with possible solution https://www.repairtoolbox.com/sqlserverrepair.html