SQL Server Performance Forum – Threads Archive
Error 3315 sev 21Hi 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
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.
ran dbcc checkdb –> did not give any errors, so would be monitoring to check if this message after couple of hours.
A supported hotfix is availablehttp://support.microsoft.com/kb/917886 for this issue Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
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.