SQLServerCentral.com / SQL Server 2005 / Data Corruption / Database Corrupt / Latest PostsInstantForum.NET v2.9.0SQLServerCentral.comhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comTue, 31 Mar 2015 12:48:44 GMT20RE: Database Corrupthttp://www.sqlservercentral.com/Forums/Topic1413293-266-1.aspxHello 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!!Mon, 04 Mar 2013 10:17:59 GMTsaifulislam6720RE: Database Corrupthttp://www.sqlservercentral.com/Forums/Topic1413293-266-1.aspxNo clean backup I assume...Script all objects (some will fail)Export all data (some will fail)Recreate the database.Tue, 29 Jan 2013 13:20:22 GMTGilaMonsterDatabase Corrupthttp://www.sqlservercentral.com/Forums/Topic1413293-266-1.aspxHi , 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 1System 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 1Table error: alloc unit ID 262144, page (1:148). The test (IS_OFF (BUF_IOERR, pBUF-&gt;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 Tue, 29 Jan 2013 13:11:39 GMTkristof 75250