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