• Dear Gail,

    Thanks for reply,

    I have used that command and it returned about 3000 line of error code:

    This is last lines.

    Server: Msg 8948, Level 16, State 1, Line 1

    Database error: Page (1:7335) is marked with the wrong type in PFS page (1:1). PFS status 0x70 expected 0x60.

    Server: Msg 8966, Level 16, State 1, Line 1

    Could not read and latch page (1:7335) with latch type SH. VerifyPageId failed.

    CHECKDB found 1563 allocation errors and 0 consistency errors not associated with any single object.

    CHECKDB found 1563 allocation errors and 0 consistency errors in database 'FAQ'.

    repair_allow_data_loss is the minimum repair level for the errors found by DBCC CHECKDB (FAQ ).

    Then I used this commands:

    ALTER DATABASE FAQ

    SET single_user WITH ROLLBACK IMMEDIATE;

    go

    DBCC checkdb ('FAQ', repair_allow_data_loss);

    go

    it returned 500 line of report (some errors and some repaired text) with this line at the end;

    CHECKDB found 1000 allocation errors and 0 consistency errors in database 'FAQ'.

    CHECKDB fixed 500 allocation errors and 0 consistency errors in database 'FAQ'.

    repair_fast is the minimum repair level for the errors found by DBCC CHECKDB (FAQ repair_allow_data_loss).

    DBCC execution completed. If DBCC printed error messages, contact your system administrator.

    then i used :

    ALTER DATABASE FAQ

    SET single_user WITH ROLLBACK IMMEDIATE;

    go

    DBCC checkdb ('FAQ',repair_fast );

    go

    and it returned 500 line of report (some errors and some repaired text) with this line at the end(like before);

    CHECKDB found 1000 allocation errors and 0 consistency errors in database 'FAQ'.

    repair_allow_data_loss is the minimum repair level for the errors found by DBCC CHECKDB (FAQ repair_fast).

    DBCC execution completed. If DBCC printed error messages, contact your system administrator.

    and the loop is continued.

    what should i do now??!!?!?:(

    Best Regards,
    Ashkan