Changing database to Read_Write

• sunny.tjk

  SSCertifiable

  Points: 5041

  More actions

  January 28, 2013 at 2:36 pm

  #269605

  I've a read-only database and I'd like to change it to read_write but the following script never seems to complete. Not sure where I'm going wrong.

  USE DatabaseName

  go

  ALTER DATABASE [DatabaseName] SET READ_WRITE

  GO

  Is there an alternative method?

• arnipetursson

  SSCertifiable

  Points: 6557

  More actions

  January 28, 2013 at 2:44 pm

  #1581822

  You could add "WITH NO_WAIT"

• dbafromthecold@gmail.com

  SSChampion

  Points: 10160

  More actions

  January 29, 2013 at 6:48 am

  #1582108

  Would [WITH ROLLBACK IMMEDIATE] help?

  Andrew

• sunny.tjk

  SSCertifiable

  Points: 5041

  More actions

  January 29, 2013 at 1:02 pm

  #1582330

  Andrew Pruski (1/29/2013)

  ---

  Would [WITH ROLLBACK IMMEDIATE] help?

  Andrew

  Thanks Andrew. This worked. I'll read further on ROLLBACK IMMEDIATE.

• dbafromthecold@gmail.com

  SSChampion

  Points: 10160

  More actions

  January 29, 2013 at 1:09 pm

  #1582339

  No worries, good link

  http://blog.sqlauthority.com/2010/03/17/sql-server-difference-between-rollback-immediate-and-with-no_wait-during-alter-database/

  Summary

  No Wait - will cause the statement you are executing to fail if there are open transactions

  Roll back Immediate - will rollback open transactions when you execute your script (an override I guess)

  Andrew