August 21, 2005 at 8:03 pm
Hi all,
Whenever i issue this command DBCC SHRINKDATABASE the below message appear.
Server: Msg 1205, Level 13, State 57, Line 1
Transaction (Process ID 51) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
Could help me please?
I got no way out...
Thanks, in advance, for helping me.
Lux
August 21, 2005 at 10:00 pm
Hi,
Becareful to kill that spid that is in use
kill spid number
-------------
when u use shrink database then no user should be connected on that database.This error comes when the tables are in use.
U can expand the management node go to current activity and see the process info.
U can see how many process are in que.
Better to use shrink batabase shrink the files(Logfiles)
hope this helps u.
from
killer
August 23, 2005 at 11:57 am
I would not 'kill' things indiscriminately ... For example if your database recovery mode is 'full', the competing proces may have been a transaction log dump. The competing process could have been a production update of a table. No matter what the recovery mode, a full database backup, optimizatinos or integrity check may have been executing. Research, time and patience are your allies.
RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply