Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2003-05-22 : 08:08:17
|
| Vijay writes "Hi,When I try to run this command "DBCC SHRINKDATABASE ([DBNAME])"from sql job, I am getting "Transaction (Process ID 58) was deadlocked on lock | communication buffer resources with another process and has been chosen as the deadlock victim. Rerun the transaction. [SQLSTATE 40001] (Error 1205). The step failed."I am sure I am not running any other sql job or any updates to the db at the same time. Even when I tried to run the command from sql query analyser at different time, I am getting the same error message.I would appriciate if you could help me figure this out.Thanks,-Vijay" |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-05-22 : 12:23:35
|
| You should run sp_who in Query Analyzer to figure out what else is running when you try to run that command. Also you might want to put your database in single user mode to do this. If you can't get SHRINKDATABASE to run then try SHRINKFILE.Tara |
 |
|
|
|
|
|
deadlock error on SHRINKDATABASE