• I don't have clean backup. For some reason, my customer stopped weekly backup and the last backup is several month ago

    Since you don't have backup , try to repair the database,

    TRY

    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

    CAUTION : There is a high chance of data loss

    If you mange to get database online, make sure you implement database backup strategy

    SQL 2000/2005/2008/2012 DBA - MCTS/MCITP