Make SQL Server DB Read Only/Read-Write Only

5 Replies

Read Only
You can add the database in readonly mode by using below query. You can not add, update or delete any records once database is in read only mode.

ALTER DATABASE SQLDBPOOL set READ_ONLY
GO

READ_WRITE
You can set the database again in to Read/Write mode using below query.
ALTER DATABASE SQLDBPOOL SET READ_WRITE WITH NO_WAIT GO

5 thoughts on “Make SQL Server DB Read Only/Read-Write Only”

sushil September 30, 2011 at 11:51 am

its not workin for me..

Reply ↓
1. Jugal Shah Post authorOctober 10, 2011 at 1:17 pm
  
  what error you are getting?
  
  Reply ↓
P.V.Rajagopal February 19, 2015 at 11:34 am

Thank you for you information

Reply ↓
Amir Ali November 14, 2016 at 8:52 pm

Small Correction: ALTER DATABASE XXX SET READ_WRITE WITH NO_WAIT

Reply ↓
1. Jugal Shah Post authorJanuary 30, 2017 at 8:20 am
  
  Thanks
  
  Reply ↓

Thanks for the comment, will get back to you soon... Jugal Shah Cancel reply