Pełny komunikat (3314):
During undoing of a logged operation in database 'MyDB’, an error occurred at log record ID (206671:82089:65). Typically, the specific failure is logged previously as an error in the Windows Event Log service. Restore the database or file from a backup, or repair the database.
a poprzedni komunikat to (1203):
Process ID 123 attempted to unlock a resource it does not own: PAGE: 9:5:7933. Retry the transaction, because this error may be caused by a timing condition. If the problem persists, contact the database administrator.
Cóż robić?
1. Uruchom DBCC:
dbcc checkdb (’OperationsManagerDW’) with no_infomsgs
2. Jeśli nic nie zostanie znalezione – jesteś uratowany
3. Jeśli będzie błąd: backup i spróbuj REPAIR_REBUILD (w SINGLE_USER)
4. A jeśli i to nie pomoże to cytuję „Restore the database or file from a backup, or repair the database.”
Inne rozwiązania:
http://dba.stackexchange.com/questions/39066/process-attempted-to-unlock-a-resource-it-does-not-own
http://technet.microsoft.com/en-us/library/cc280639.aspx
http://support.microsoft.com/kb/2015741
