Drop database Failed

• VastSQL

  SSC-Dedicated

  Points: 36121

  More actions

  June 26, 2013 at 7:45 am

  #395042

  Hi Experts,

  I am getting deadloack error when tried to delete a large DB. The db is have 4 processes which are blocked by one or the other ,all the processes are system processes.

  Msg 1205, Level 13, State 30, Line 1

  Transaction (Process ID 52) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.

  Please help.

• J Good

  Default port

  Points: 1435

  More actions

  June 26, 2013 at 2:11 pm

  #1627723

  Try setting the database to restricted_user first and see if that helps:

  ALTER DATABASE [YourDbName]

  SET RESTRICTED_USER WITH ROLLBACK IMMEDIATE;

  Twitter: @SQL_JGood
  Blog: sqljgood.wordpress.com/[/url]

• Michael Valentine Jones

  SSC Guru

  Points: 64818

  More actions

  June 26, 2013 at 3:12 pm

  #1627748

  This will usually work to drop a database that is being used.

  use master;

  alter database [MyDatabase] set offline with rollback immediate;

  alter database [MyDatabase] set online with rollback immediate;

  drop database [MyDatabase];