Home / Software / Tips and Tricks / Changing a Read Only Database to Read/Write mode OR changing a Read/Write database to Read-Only mode

Changing a Read Only Database to Read/Write mode OR changing a Read/Write database to Read-Only mode

Updated:  10/17/2011 06:10 AM
Author:  Shiju Mathews

Status:    Resolved.


When are working with databases we need to change the database mode between to Read/Write to Read-Only mode or vice versa for different operation.

Usually this is happen when we are trying to attach database back up created by users. Or we need to change database mode to Read-Only when we are not updating the database.

The following script can be change the Modes.
“CourtesyIndiaDB” is my database that I need to change the modes. I used SQL Server 2008

Make Database Read-Only Mode


To Make Database Read/Write Mode