dbcc commands are allowed in an archive database:
checkdb
checkcatalog
The fix version of checkcatalog is
not supported.
checktable
checkindex
checkalloc
checkstorage
indexalloc
tablealloc
textalloc
While dbcc commands are executing, other users cannot access an archive database. If you attempt to access an archive database while dbcc commands are being performed, you receive a message saying that the database is in single-user mode.
You can use variants of the above dbcc commands on an archive database that is online or offline. However, you can use a dbcc command with a fix option only on an archive database that is online.
