Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

endless Loop in database repare Expand / Collapse
Author
Message
Posted Saturday, October 16, 2010 8:51 AM


SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Monday, September 30, 2013 5:05 AM
Points: 94, Visits: 232
Dear friends,
My data base has corrupted and I need help.
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
Posted Saturday, October 16, 2010 9:21 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 2:50 AM
Points: 42,451, Visits: 35,506
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 »

Add to briefcase

Permissions Expand / Collapse