Setting A Database to Read Only

You probably won't do this often, but it's a quick and easy way to make sure nothing changes. It's a lot simpler than modifying permissions within the database, and so it's easy to undo the change when it's time to do that. I use this technique when I'm pretty sure a database isn't being used, first setting it to read only and then later changing it to offline.

Andy Warren is a software trainer focusing on SQL Server, a member of the PASS Board of Directors, and a principal in this site - SQLShare.com.

Alexander on 1/25/2011

very nice

Will Casey on 1/25/2011

obvious but great tip

Scott Schommer on 1/25/2011

Clear and concise

Sean Paul Hendrix on 1/25/2011

The delivery was very concise, methodical and very easy to follow. Thank you.

995751D667 on 1/25/2011

clear, straight forward, and thorough

WChaster on 1/25/2011

After deleting the last record and setting the datbase to Read Only one should expect the error stating the database is in Read Only mode, reporting zero rows delete is a bad return message, imho.

Leonard Peoples on 1/25/2011

Very helpful.

kishanchandra golla on 1/25/2011

good Video

Marcelo Marim on 1/25/2011

Thank you for your video.

John Breidenbach on 1/25/2011

Nice explaination

Satyabodhi Densmore on 1/25/2011

Should mention the other options like "with rollback immediate". Setting the database to read-only is a big pain if you update as frequently as once per month. In this case, it is better to use the deny and revoke verbs. Even though that is more complicated, you don't have to reset the modes every time you want to update tables or alter objects.

Raymond Zayas on 1/26/2011

Excellent.

gabirulucas on 1/30/2011

Cool

Julie Breutzmann on 2/1/2011

Our read-only databases are gray instead of yelow and the name is followed by (Read-Only). Is this a setting? I find it very useful for us.

Maurice Ivory on 2/9/2011

I think this will be very usefull!!!

Harold Brangman on 2/15/2011

Love it. Definitely will be trying it soon.

se on 11/1/2011

great