September 2, 2016 at 3:59 pm
Hello everybody!
We have a corruption in our database and don't find any solution. Also, MS support was not very helpful until now.
Maybe somebody had this issue and could give us some feedback.
We use as SQL Server 2014 Enterprise Cluster, SP2. When we tried to restore a backup, we received the following error message:
Msg 608, Level 16, State 1, Line 283
No catalog entry found for partition ID xxx in database yyy. The metadata is inconsistent. Run DBCC CHECKDB to check for a metadata corruption.
So we did run CHECKDB and didn't get any results. After we used WITH EXTENDED_LOGICAL_CHECKS, we received the same error message on our productive system. Just to be sure, we also checked each user table with CHECKTABLE and didn't get any error messages.
I guess it's connected to the full text index in one table. We can't rebuild or drop the index, catalog or anything else connected.
Does anybody have any ideas what it could be or how we could fix this? Is there a way to drop/delete indexes directly from sys tables?
The only alternative we see at the moment would be to create a new db and copy all data there. With 750GB and a short maintenance window, this would be a real disaster.
Thanks a lot for any help in advance!
Cheers,
Juergen
September 3, 2016 at 3:41 am
Can you post the full unedited output of
DBCC CheckDB ('DB_NAME') WITH NO_INFOMSGS, ALL_ERRORMSGS;
😎
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply