Msg 1205 Transaction (Process ID 75) was deadlocked on lock |

Hi:

On a production SQL2000 STD sp4 server,

1. I have dropped 10 tables with each around 1-2 gb in DB ABC
2. I had run DBCC ShrinkDatabase (ABC, 20) and it is failed after running 133 hours this morning. Yes, 133 hours.

It ran 72 hours last month and shrinked from 200 gb to 180 gb.
Thus, I expected it should be <= 72 hours to fnish since 10 more tables are dropped ?

Msg 1205 Transaction (Process ID 75) was deadlocked on lock | communication buffer resources with another process and has been chosen as the deadlock victim. Rerun the transaction.

DBCC shrinkDatabase will cause deadlocking? how to avoid it?
Is there other ways to speed up?

thanks
-D

Did you see blocking during that time period? That will slow down db shrinking. What kind of apps use the db? Maybe deadlock on system tables, check sql server log for details.