SET DB option taking very long to run

• Mike Levan

  SSChampion

  Points: 14201

  More actions

  November 6, 2008 at 10:23 am

  #200945

  I am trying to set DB to read/write by using

  ALTER DATABASE mydb SET READ_WRITE

  its a small DB when comapred to other, but other db's doing quick. what might be the reason.

• noeld

  SSC Guru

  Points: 96590

  More actions

  November 6, 2008 at 1:54 pm

  #895207

  If there are other connections on the DB you will be blocked.

  Any change from read_only to read_write and viceversa requires exclusive access

  you either are the only one connected to it or kill all other connections to the make that change

  
  * Noel