What is the purpose of read-only databases?
What is the purpose of read-only databases?
The main purpose of making a database a read-only is to restrict the users from modifying certain aspects of the database. For example when a database is in read-only mode, an auto-shrink, auto statistics and some other commands won’t work. This helps to stop the users who are allowed to access the databases but are not experts in database modification from messing up the database. So they can read the information but cannot modify it. Read-only databases are the best practices when it comes to sharing a databases with multiple parties. They can access the database but cannot modify it accidently or intentionally.