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.

Note: You cannot change the SAP ASE default character set and sort order if it includes an archived database.