How to set a MSSQL database to read-only mode?
To Set a database to read-only mode in MSSQL:
Go to the appropriate DATABASE, right click, PROPERTIES, go under OPTIONS, and you will see DATABASE READ-ONLY.
Set this property to TRUE.
Alternatively, you can do this in T-SQL:
ALTER DATABASE [Database Name] SET READ_ONLY WITH NO_WAIT
To Set the database back to Read+Write mode:
ALTER DATABASE [Database Name] SET READ_WRITE WITH NO_WAIT
If you are experiencing issues with ScaleArc or with any of it's features, please contact ScaleArc Support.
We are available 24x7 by phone at 855 800 7225 or +1 408 412 7315.
For general support inquiries, you can also e-mail us at firstname.lastname@example.org.