Deadlock issue | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Deadlock issue

Today when I tried to shrink a DB I got the following error."Error 1205:Transaction(Process ID 97) was deadlocked on lock resources with another process and has been chosen as the deadlock victim.Rerun the transaction"
What is wrong and how.?How to resolve it
As per my knowledge sql server is capable of handling deadlock.But still this error came.
Refer this on how to reduce deadlocks
http://www.sql-server-performance.com/deadlocks.asp
Madhivanan Failing to plan is Planning to fail
I believe most of your questions within last 2 days seems to be repetitive from your ealier posts.
Anyway you got the answers and follow them. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
]]>