Make a SQL Server Database Read Only

Usually a database is made read-only when you have to migrate a database to another server for running reports. Before the migration, here’s how to make a SQL Server Database ReadOnly so that data cannot be modified during the process

-- read only
ALTER DATABASE MYDB
SET READ_ONLY
GO

Once in a Read-Only mode, you cannot add new records, update or delete records.

To set the database back to read-write mode use this query:

ALTER DATABASE MYDB
SET READ_WRITE
GO

Now records can be added, deleted or modified.