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

 

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s