Working with an archive database

Many traditional database operations are possible on an archive database. However, user-defined transactions and commands that modify the database such as such as insert, update, and delete are not allowed.

A populated archive database is similar to a read-only database where the 'readonly' option has been applied using the sp_dboption stored procedure.