How to put SQL Server Database in Read Only Mode?

How to put SQL Server database in read only mode?

There are couple of ways you accomplish this task, using T-SQL database configuration statement or using SQL Server management studio. This article illustrates how to put database in read only mode using management studio.

1- Open SQL Server Management Studio

2- Connect to the SQL Server instance where your desired database resides

3- Right click on the database and go to properties

4- Click on Option

5- Navigate to State and find Database Read-Only option

6- Set Read-Only option to True

Fig 1. How to set SQL Server Database to Read only mode

Fig 2. How to set SQL Server Database to Read only mode

Fig 3. How to set SQL Server Database to Read only mode