dbcc Commands for Archive Databases

A number of dbcc commands are allowed in an archive database.

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.