Change your database mode from Read only to Read write and vice versa

Dear Friends,

Some time you want to change your database mode like make your database to read only and then again read write mode. So the simple scripts which help you to make your database read only

 ALTER DATABASE YourDatabaseName  SET READ_ONLY WITH NO_WAIT

With the above command your database comes in Read only mode

Now how can you change the mode back to read write mode So below is the again simplest script

ALTER DATABASE YourDatabaseName SET READ_WRITE WITH NO_WAIT

With  the above command your database comes in read write mode

Thanks & best regards,

Rajat Jaiswal