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

Could not open File Control Bank (FCB) for invalid file ID Expand / Collapse
Author
Message
Posted Wednesday, March 13, 2013 10:57 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Thursday, July 24, 2014 7:55 PM
Points: 6,582, Visits: 8,860
Initial entry in the SQL Error Log:
Error: 5180, Severity: 22, State: 1.
Could not open File Control Bank (FCB) for invalid file ID 2816 in database 'WSS_Content_FirmMySites'. Verify the file location. Execute DBCC CHECKDB.

So, run DBCC CHECKDB WITH ALL_ERRORMSGS, NO_INFOMSGS
Complete, unedited results:
Msg 7987, Level 16, State 1, Line 1
System table pre-checks: Object ID 3 has chain linkage mismatch. (1:223355)->next = (1:223357), but (1:223357)->prev = (1:223356). Check statement terminated due to unrepairable error.

Try DBCC CHECKALLOC
Msg 7987, Level 16, State 1, Line 1
System table pre-checks: Object ID 3 has chain linkage mismatch. (1:223355)->next = (1:223357), but (1:223357)->prev = (1:223356). Check statement terminated due to unrepairable error.

This is a new client, so see when DBCC CHECKDB was last successfully run via DBCC PAGE(dbname, 1,9,3) WITH TABLERESULTS:
2011-10-31 01:10:06.737

Check the previous backup in a parallel database: same errors as above.
Backups older than this have already been deleted.

This database is part of a sharepoint instance.
DBCC CHECKDB did generate a stack dump.

Is there anyway to fix this corruption?


Wayne
Microsoft Certified Master: SQL Server 2008
If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
Links: For better assistance in answering your questions, How to ask a question, Performance Problems, Common date/time routines,
CROSS-TABS and PIVOT tables Part 1 & Part 2, Using APPLY Part 1 & Part 2, Splitting Delimited Strings
Post #1430533
Posted Wednesday, March 13, 2013 10:58 AM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Today @ 4:21 PM
Points: 21,228, Visits: 14,933
Are you asking if there is a way to fix without losing data?



Jason AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server


SQL RNNR

Posting Performance Based Questions - Gail Shaw
Posting Data Etiquette - Jeff Moden
Hidden RBAR - Jeff Moden
VLFs and the Tran Log - Kimberly Tripp
Post #1430535
Posted Wednesday, March 13, 2013 11:12 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 @ 3:46 PM
Points: 42,462, Visits: 35,525
Restore from last good backup, that's irrepairable.

If there's absolutely no backup whatsoever, export all the documents, lists, etc from sharepoint (not a SQL data export), then drop and recreate the sharepoint site. You'll probably lose some stuff.



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 #1430536
Posted Wednesday, March 13, 2013 11:36 AM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Today @ 4:21 PM
Points: 21,228, Visits: 14,933
GilaMonster (3/13/2013)
Restore from last good backup, that's irrepairable.

If there's absolutely no backup whatsoever, export all the documents, lists, etc from sharepoint (not a SQL data export), then drop and recreate the sharepoint site. You'll probably lose some stuff.


I had just been talking to Wayne about the eventuality of most likely having to recreate the sharepoint site.

Have a fun day with this new client, Wayne.




Jason AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server


SQL RNNR

Posting Performance Based Questions - Gail Shaw
Posting Data Etiquette - Jeff Moden
Hidden RBAR - Jeff Moden
VLFs and the Tran Log - Kimberly Tripp
Post #1430545
Posted Thursday, March 14, 2013 4:08 AM


SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, July 16, 2014 5:10 AM
Points: 112, Visits: 1,207
You can also try Third Party SharePoint Recovery Tool to fix corruption. For more information, please check this site.

SQL Database Recovery Expert
Post #1430853
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse