I have one database that is marked "suspect". I want to try to repair it rather that restoring it from backup. Is this possible using the following commands:
ALTER DATABASE Altiris
SET db_state_option = EMERGENCY;
DBCC CHECKDB repair_allow_data_loss;
Please review this for errors. Also, if this does not work, will I have to set the database to offline to do the restore from backup?