SQL Server Read Only DataBases usage advantages & areas

We can set our DataBase read-only, and it restricts some commands like Auto-Shrink, Auto Statistics, and DBCC commands. But it also gives a high performance with limiting that features.
We can use


command to set DB read only. But, why we should use Read Only Databases? What are the advantages, and what are the usage areas?
Thank you.

  • SQL Server SELECT INTO @variable?
  • Database design, multiple types of customers in the same table
  • What options are available for connecting to a Microsoft SQL Server database from an Oracle database?
  • Dimension Attribute not showing up in Business Intelligence Dev Studio
  • Get specific time threshold in SQL
  • Last non Null in a Pivot SQL query
  • 3 Solutions collect form web for “SQL Server Read Only DataBases usage advantages & areas”

    Some times you may have a database which is shared by a publisher – historical data, stock data, statistics, studies. Or potentially your own archived data.

    It may or may not start as a SQL Server database, but the data is static.

    You never want it to be altered by anyone at all, accidentally or intentionally.

    Databases that are read only?

    For examlple lookup data that you buy that is regularly replaced but read only under normal circumstances.

    You’d normally use a read only filegroup not an entire read only database.

    However, you may have a legacy database that no-one should update for example.

    MS SQL Server is a Microsoft SQL Database product, include sql server standard, sql server management studio, sql server express and so on.