endless Loop in database repare

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 7,2000 » Data Corruption » endless Loop in database repare

endless Loop in database repare

Rate Topic

Display Mode

Topic Options

Author

Message

ashkan siroos

Posted Saturday, October 16, 2010 8:51 AM

SSC Journeyman

Group: General Forum Members
Last Login: Sunday, May 19, 2013 5:15 AM
Points: 93, Visits: 230

Dear friends,
My data base has corrupted and I need help. Sad

I have execute: DBCC CHECKDB (<Database Name>) WITH NO_INFOMSGS, ALL_ERRORMSGS and it returned 3000 line of error and this lines on the end:
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??!!?!? [Sad]

Thanks and regards,
Ashkan

Post #1005752

GilaMonster

Posted Saturday, October 16, 2010 9:21 AM

SSC-Dedicated

Group: General Forum Members
Last Login: Today @ 9:46 AM
Points: 37,712, Visits: 29,966

Duplicate post. No replies to this thread please. Direct replies to:http://www.sqlservercentral.com/Forums/Topic1005710-265-1.aspx

Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #1005756

« Prev Topic | Next Topic »

Permissions