cannot put DB offline

• DBA-640728

  SSChampion

  Points: 12898

  More actions

  August 14, 2008 at 3:49 pm

  #191254

  Hi

  When I try to put the database offline by clicking to the right, tasks, take offline:

  I am getting this error message :

  Server: Msg 5061, Level 16, State 1, Line 16

  ALTER DATABASE failed because a lock could not be placed on database 'mydatabase'. Try again later.

  Server: Msg 5069, Level 16, State 1, Line 16

  ALTER DATABASE statement failed.

  I tried this

  USE MASTER

  Go

  alter database DBName set with rollback immediate

  same error.. any ideas why?

• Michael Valentine Jones

  SSC Guru

  Points: 64818

  More actions

  August 14, 2008 at 4:52 pm

  #858493

  Some other connection might have the database open in single user mode.

  You would have to kill that connection before the database can be set offline.