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.

  • how to write number to word function in sql server
  • (sql) how can I use count() method when data type is text?
  • SQL Server : error converting data type varchar to numeric
  • Using SQL Server as Image store
  • SqlDataAdapter.Fill(DataTable) not filling DataTable
  • SQL Server pivot vs. multiple join
  • 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.