Working with an archive database

You can perform many traditional database operations 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 sp_dboption.