The following dbcc commands are allowed in an archive database:
checkdb
checkcatalog
The fix version of checkcatalog is
not supported.
checktable
checkindex
checkalloc
indexalloc
tablealloc
textalloc
dbcc commands prevent other users from accessing an archive database while they are executing. 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.
