• I know it's been a few months, so you have probably fixed this one way or another.

    I have the situation where I have to keep databases online. Data integrity is second (non-financial), so corrupted records can be compared and fixed when it is convenient. Therefore, I use something called "EMERGENCY" mode.

    I would recommend making a copy of the MDF/LDF first, as this technique can cause data loss. In a pinch, it has served me well many times, and I have yet to lose anything too valuable. This is also useful when you can't get a database to even go into single user mode to attempt repairs, or when you can't run backups because it just throws torn page errors.

    ALTER DATABASE corrupted_db SET EMERGENCY

    ALTER DATABASE corrupted_db SET SINGLE_USER WITH ROLLBACK IMMEDIATE

    DBCC ChECKDB ('corrupted_db', REPAIR_ALLOW_DATA_LOSS)

    ALTER DATABASE corrupted_db SET MULTI_USER