Tuesday, December 9, 2014

Database Read_Only Vs Read_Write

Some times, You may get a situation like need to make your database as read_only time being...
Please follow the below..

If you want to make you database set to read only from (READ_WRITE) Normal DB,Then you can follow below
Note: Conditions apply, You will have to disconnect users from respected database.
USE [master]
GO
ALTER DATABASE [DatabaseName] SET  READ_ONLY WITH NO_WAIT
GO
If you want to make your database set to REGULAR(READ and WRITE), Then you can follow below...
Note: Conditions apply, You will have to disconnect users from respected database.

USE [master]
GO
ALTER DATABASE [DatabaseName] SET  READ_WRITE WITH NO_WAIT
GO

No comments:

Post a Comment