• Did you by chance reboot the service/server in an attempt to kill a long-running transaction or try to remediate a transaction that had been killed and was in the process of rolling back?

    What is the state of the database?

    SELECT name,

    state_desc

    FROM sys.databases

    WHERE name = N'yourDBname';

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato