During undoing of a logged operation in database ‚MyDB’, an error occurred…

14-Kwi-2014

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://blogs.msdn.com/b/sqlsakthi/archive/2012/05/08/inf-what-happens-to-a-database-when-transaction-rollback-fails.aspx

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

Dodaj komentarz:

Autor: Rafał Kraik