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

Database Corrupt Expand / Collapse
Author
Message
Posted Tuesday, January 29, 2013 1:11 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Sunday, February 3, 2013 2:04 AM
Points: 1, Visits: 10
Hi , Last week we have a server crash in the datacenter .
one of our customers use a SQL Database.
When I would restore / attach the mdf , I get a a lot of errors .

When we execute the following query :
DBCC CHECKDB (BPO, REPAIR_ALLOW_DATA_LOSS)

Error:
Msg 7985, Level 16, State 2, Line 1
System table pre-checks: Object ID 4. Could not read and latch page (1:148) with latch type SH. Check statement terminated due to unrepairable error.
DBCC results for 'Exp_0700SWPDeLoods'.
Msg 5233, Level 16, State 98, Line 1
Table error: alloc unit ID 262144, page (1:148). The test (IS_OFF (BUF_IOERR, pBUF->bstat)) failed. The values are 29362185 and -1.
CHECKDB found 0 allocation errors and 1 consistency errors not associated with any single object.
CHECKDB found 0 allocation errors and 1 consistency errors in database 'Exp_0700SWPDeLoods'.

We also try to update the status from the systables , also without any result

We hope someone could help us out .
When you need the mdf file , I could send you
Post #1413293
Posted Tuesday, January 29, 2013 1:20 PM


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 @ 12:11 PM
Points: 42,470, Visits: 35,541
No clean backup I assume...

Script all objects (some will fail)
Export all data (some will fail)
Recreate the database.



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 #1413302
Posted Monday, March 4, 2013 10:17 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, March 6, 2013 9:36 AM
Points: 5, Visits: 8
Hello Guys i think that database corruption is damage to a Q&A database that angers its reliability and usually affects its performance.Database corruption is not limited to Q&A.when data corruption happens, the data file containing that data may become unavailable, and the system or the related program will give one.Thanks a lot!!
Post #1426355
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse