• dbcc checkdb can repair some things - see bol. Make sure you have a backup first.

    sometimes suspect status can be reset.

    call microsoft technical support

    apexSQL log may be able to help you recover data and objects.

    Best,
    Kevin G. Boles
    SQL Server Consultant
    SQL MVP 2007-2012
    TheSQLGuru on googles mail service