Originally Posted by JamesNT
Using SQL Server Management Studio you may indeed set an entire database to read only.

Two things to keep in mind:

1. You must have a SQL Server account with access to log on to the SQL Server.

2. Making the database read-only may break Amazing Charts. Like many programs, Amazing Charts may write information to the database just by turning it on. For example, some programs keep track of when they are started or when a login fails or is successfully by writing that information to the database.

JamesNT

James is correct that this will 'break' some of the AC functionality; the question is if the errors that it throws are acceptable for the purpose that you have in mind.

Another thing to keep in mind is that with every restore, interfaces are activated, processes run, etc. so there are more moving pieces in play than meets the eye


Indy
"Boss"

Indy's Blog

www.BestForYourPractice.com
Our Name is Our Creed