Error 3315 sev 21 | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Error 3315 sev 21

Hi All, We were seing this error message which was occuring randomly in one of our server whole day yesterday , so thought of asking you folks suggestions Enviornment:
————
SQL server 2005 SP1
datbase size 45GB
Nightly Backup
No transactional log back as of now. Message
——-
Error: 3315, Severity: 21, State: 1. During rollback, the following process did not hold an expected lock:
process 78 with mode 8 at level 2 for row Rid pageid is (1:5553713)
and row num is 0x12 in database ‘fin_prod’ under transaction (0:16218922).
Restore a backup of the database, or repair the database.
Steps:
——
ran dbcc checkdb –> did not give any errors, so would be monitoring to check if this message after couple of hours.
Cheers
Sat[?]
A supported hotfix is availablehttp://support.microsoft.com/kb/917886 for this issue Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.
Thx…Satya. Cheers
Satish
]]>