ashkan siroos (10/16/2010)
Dear Gail,Thanks for reply,
I have used that command and it returned about 3000 line of error code:
I need to see them ALL to give you any useful advice. Save the list in a text file, zip and attach to your post.
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;
*sigh* Repair is never the first resort for fixing corruption. Done is done I suppose, do you have any idea how much data the repair lost?
and the loop is continued.
what should i do now??!!?!?:(
Without seeing all the errors, I can't give you a definitive answer, but likely either you have an IO subsystem that's producing corruption faster than you can fix it, or you have something that's irreparable.
Do you have a clean backup of this database?
I think i should post a new topic for this error
I think you should not. No point having multiple posts for the same problem, one will just get locked.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability