You can use a number of SQL commands in an archive database.
alter database
load database
online database
drop database
load tran
use
select
select into – where the target database is not an archive database.
Cursor operations that perform reads, including:
declare cursor
deallocate cursor
open
fetch
You cannot use an updatable cursor.
checkpoint – is a supported command. However, the checkpoint process does not automatically checkpoint an archive database.
execute – is allowed as long as any statements that reference the archive database are allowed within the archive database. A transaction inside or outside a stored procedure is not permitted with an execute command.
lock table
readtext