Good day.
I am trying to check and repair the damaged table, but I get back
Check statement aborted. Database contains deferred transactions.
In the course of research, it was found out that the process with SPID 5 and the DB STARTUP command has been blamed for a long time, however dbcc opentran shows that there are no active transactions, dbcc inputbuffer shows nothing for this process, and the logs say that recovery was successful is over.
Attempts to transfer the database to single_user, emergency or offline failed. Rebooting does not help. From the backup, the database is already deployed in this state and there is no possibility to use any earlier ones.
Google does not give any intelligible advice. I hope for your help.
Thank.
