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 12»»

DBCC CHECKDB Error? Expand / Collapse
Author
Message
Posted Tuesday, December 18, 2012 5:12 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Wednesday, April 16, 2014 11:56 PM
Points: 1,015, Visits: 2,840
Hi,

Backup failed as below error messages, after that verify DBCC CHECKDB <DBNAME> WITH DATA_PURITY.

Failed-1073548784) Executing the query "BACKUP DATABASE [BaseComponents] TO DISK = N'E:\\S..." failed with the following error: "Read on "D:\\Data\\Microsoft SQL Server\\MSSQL10.MSSQLSERVER\\MSSQL\\DATA\\BaseComponents.mdf" failed: 23(Data error (cyclic redundancy check).)
BACKUP DATABASE is terminating abnormally.

Please provide the solution for the database consistancy error

Error mesages
 DBCC results for 'BaseComponents'.
Service Broker Msg 9675, State 1: Message Types analyzed: 14.
Service Broker Msg 9676, State 1: Service Contracts analyzed: 6.
Service Broker Msg 9667, State 1: Services analyzed: 3.
Service Broker Msg 9668, State 1: Service Queues analyzed: 3.
Service Broker Msg 9669, State 1: Conversation Endpoints analyzed: 0.
Service Broker Msg 9674, State 1: Conversation Groups analyzed: 0.
Service Broker Msg 9670, State 1: Remote Service Bindings analyzed: 0.
Service Broker Msg 9605, State 1: Conversation Priorities analyzed: 0.
Msg 8966, Level 16, State 2, Line 1
Unable to read and latch page (1:542654) with latch type SH. 23(Data error (cyclic redundancy check).) failed.
Msg 8966, Level 16, State 2, Line 1
Unable to read and latch page (1:542686) with latch type SH. 23(Data error (cyclic redundancy check).) failed.
CHECKDB found 0 allocation errors and 2 consistency errors not associated with any single object.
DBCC results for 'sys.sysrscols'.
There are 1353 rows in 15 pages for object "sys.sysrscols".
DBCC results for 'sys.sysrowsets'.
There are 233 rows in 2 pages for object "sys.sysrowsets".
DBCC results for 'sys.sysallocunits'.
There are 261 rows in 4 pages for object "sys.sysallocunits".
DBCC results for 'sys.sysfiles1'.
There are 2 rows in 1 pages for object "sys.sysfiles1".
DBCC results for 'sys.syspriorities'.
There are 0 rows in 0 pages for object "sys.syspriorities".
DBCC results for 'sys.sysfgfrag'.
There are 2 rows in 1 pages for object "sys.sysfgfrag".
DBCC results for 'sys.sysphfg'.
There are 1 rows in 1 pages for object "sys.sysphfg".
DBCC results for 'sys.sysprufiles'.
There are 2 rows in 1 pages for object "sys.sysprufiles".
DBCC results for 'sys.sysftinds'.
There are 3 rows in 1 pages for object "sys.sysftinds".
DBCC results for 'sys.sysowners'.
There are 15 rows in 1 pages for object "sys.sysowners".
DBCC results for 'sys.sysprivs'.
There are 134 rows in 1 pages for object "sys.sysprivs".
DBCC results for 'sys.sysschobjs'.
There are 504 rows in 9 pages for object "sys.sysschobjs".
DBCC results for 'sys.syscolpars'.
There are 1810 rows in 41 pages for object "sys.syscolpars".
DBCC results for 'sys.sysnsobjs'.
There are 1 rows in 1 pages for object "sys.sysnsobjs".
DBCC results for 'sys.syscerts'.
There are 0 rows in 0 pages for object "sys.syscerts".
DBCC results for 'sys.sysxprops'.
There are 0 rows in 0 pages for object "sys.sysxprops".
DBCC results for 'sys.sysscalartypes'.
There are 34 rows in 1 pages for object "sys.sysscalartypes".
DBCC results for 'sys.systypedsubobjs'.
There are 0 rows in 0 pages for object "sys.systypedsubobjs".
DBCC results for 'sys.sysidxstats'.
There are 439 rows in 7 pages for object "sys.sysidxstats".
DBCC results for 'sys.sysiscols'.
There are 605 rows in 4 pages for object "sys.sysiscols".
DBCC results for 'sys.sysbinobjs'.
There are 23 rows in 1 pages for object "sys.sysbinobjs".
DBCC results for 'sys.sysaudacts'.
There are 0 rows in 0 pages for object "sys.sysaudacts".
DBCC results for 'sys.sysobjvalues'.
There are 636 rows in 197 pages for object "sys.sysobjvalues".
DBCC results for 'sys.sysclsobjs'.
There are 17 rows in 1 pages for object "sys.sysclsobjs".
DBCC results for 'sys.sysrowsetrefs'.
There are 0 rows in 0 pages for object "sys.sysrowsetrefs".
DBCC results for 'sys.sysremsvcbinds'.
There are 0 rows in 0 pages for object "sys.sysremsvcbinds".
DBCC results for 'sys.sysxmitqueue'.
There are 0 rows in 0 pages for object "sys.sysxmitqueue".
DBCC results for 'sys.sysrts'.
There are 1 rows in 1 pages for object "sys.sysrts".
DBCC results for 'sys.sysconvgroup'.
There are 0 rows in 0 pages for object "sys.sysconvgroup".
DBCC results for 'sys.sysdesend'.
There are 0 rows in 0 pages for object "sys.sysdesend".
DBCC results for 'sys.sysdercv'.
There are 0 rows in 0 pages for object "sys.sysdercv".
DBCC results for 'sys.syssingleobjrefs'.
There are 363 rows in 4 pages for object "sys.syssingleobjrefs".
DBCC results for 'sys.sysmultiobjrefs'.
There are 1532 rows in 13 pages for object "sys.sysmultiobjrefs".
DBCC results for 'sys.sysguidrefs'.
There are 0 rows in 0 pages for object "sys.sysguidrefs".
DBCC results for 'sys.syscompfragments'.
There are 0 rows in 0 pages for object "sys.syscompfragments".
DBCC results for 'sys.sysftstops'.
There are 0 rows in 0 pages for object "sys.sysftstops".
DBCC results for 'sys.sysqnames'.
There are 97 rows in 1 pages for object "sys.sysqnames".
DBCC results for 'sys.sysxmlcomponent'.
There are 99 rows in 1 pages for object "sys.sysxmlcomponent".
DBCC results for 'sys.sysxmlfacet'.
There are 112 rows in 1 pages for object "sys.sysxmlfacet".
DBCC results for 'sys.sysxmlplacement'.
There are 18 rows in 1 pages for object "sys.sysxmlplacement".
DBCC results for 'sys.sysobjkeycrypts'.
There are 0 rows in 0 pages for object "sys.sysobjkeycrypts".
DBCC results for 'sys.sysasymkeys'.
There are 0 rows in 0 pages for object "sys.sysasymkeys".
DBCC results for 'sys.syssqlguides'.
There are 0 rows in 0 pages for object "sys.syssqlguides".
DBCC results for 'sys.sysbinsubobjs'.
There are 3 rows in 1 pages for object "sys.sysbinsubobjs".
DBCC results for 'sys.syssoftobjrefs'.
There are 360 rows in 5 pages for object "sys.syssoftobjrefs".
DBCC results for 'TableCellDataItem'.
There are 0 rows in 0 pages for object "TableCellDataItem".
DBCC results for 'BC_Lookup'.
There are 34 rows in 1 pages for object "BC_Lookup".
DBCC results for 'TableCellRowLocation'.
There are 0 rows in 0 pages for object "TableCellRowLocation".
DBCC results for 'TableCellType'.
There are 6 rows in 1 pages for object "TableCellType".
DBCC results for 'BC_ConfigInstance'.
There are 186 rows in 7 pages for object "BC_ConfigInstance".
DBCC results for 'TableColumn'.
There are 0 rows in 0 pages for object "TableColumn".
DBCC results for 'TableDataItem'.
There are 0 rows in 0 pages for object "TableDataItem".
DBCC results for 'TableDesign'.
There are 0 rows in 0 pages for object "TableDesign".
DBCC results for 'BC_ConfigItem'.
There are 67 rows in 2 pages for object "BC_ConfigItem".
DBCC results for 'TableDynamicVisualization'.
There are 0 rows in 0 pages for object "TableDynamicVisualization".
DBCC results for 'TableRow'.
There are 0 rows in 0 pages for object "TableRow".
DBCC results for 'BC_ConfigSchema'.
There are 49 rows in 2 pages for object "BC_ConfigSchema".
DBCC results for 'TableTimeSeriesDataItem'.
There are 0 rows in 0 pages for object "TableTimeSeriesDataItem".
DBCC results for 'TableView'.
There are 0 rows in 0 pages for object "TableView".
DBCC results for 'BC_Owner'.
There are 24 rows in 1 pages for object "BC_Owner".
DBCC results for 'BC_DataVersionInfo'.
There are 9 rows in 1 pages for object "BC_DataVersionInfo".
DBCC results for 'BC_ApplicationAudit'.
There are 0 rows in 0 pages for object "BC_ApplicationAudit".
DBCC results for 'BC_ApplicationAuditHistory'.
There are 0 rows in 0 pages for object "BC_ApplicationAuditHistory".
DBCC results for 'BC_UserDetails'.
There are 0 rows in 0 pages for object "BC_UserDetails".
DBCC results for 'BC_AuditSummary'.
There are 0 rows in 0 pages for object "BC_AuditSummary".
DBCC results for 'EXECUTEDINFO'.
There are 62 rows in 5 pages for object "EXECUTEDINFO".
DBCC results for 'EXECUTION'.
There are 33618 rows in 811 pages for object "EXECUTION".
DBCC results for 'JOB'.
There are 33 rows in 4 pages for object "JOB".
DBCC results for 'RECURRENCE'.
There are 33 rows in 4 pages for object "RECURRENCE".
DBCC results for 'HOLIDAYS'.
There are 0 rows in 0 pages for object "HOLIDAYS".
DBCC results for 'WEEKENDS'.
There are 0 rows in 0 pages for object "WEEKENDS".
DBCC results for 'EXPLORER_PRIVATE_GROUPS'.
There are 0 rows in 0 pages for object "EXPLORER_PRIVATE_GROUPS".
DBCC results for 'EXPLORER_PRIVATE_ITEMS'.
There are 0 rows in 0 pages for object "EXPLORER_PRIVATE_ITEMS".
DBCC results for 'EXPLORER_PUBLIC_GROUPS'.
There are 0 rows in 0 pages for object "EXPLORER_PUBLIC_GROUPS".
DBCC results for 'EXPLORER_PUBLIC_ITEMS'.
There are 0 rows in 0 pages for object "EXPLORER_PUBLIC_ITEMS".
DBCC results for 'BC_Printers'.
There are 2 rows in 1 pages for object "BC_Printers".
DBCC results for 'BC_ScheduleData'.
There are 3 rows in 1 pages for object "BC_ScheduleData".
DBCC results for 'ICO_Icon'.
There are 18 rows in 1 pages for object "ICO_Icon".
DBCC results for 'MSD_Master_Search_Datasource'.
There are 5 rows in 1 pages for object "MSD_Master_Search_Datasource".
DBCC results for 'NAB_Navigation_Building'.
There are 0 rows in 0 pages for object "NAB_Navigation_Building".
DBCC results for 'NAR_Navigation_Area'.
There are 0 rows in 0 pages for object "NAR_Navigation_Area".
DBCC results for 'NAS_Navigation_Site'.
There are 0 rows in 0 pages for object "NAS_Navigation_Site".
DBCC results for 'BC_ArchiveJobs'.
There are 1 rows in 1 pages for object "BC_ArchiveJobs".
DBCC results for 'NCA_Navigation_Categories'.
There are 0 rows in 0 pages for object "NCA_Navigation_Categories".
DBCC results for 'NML_NAS_MSD_Link'.
There are 0 rows in 0 pages for object "NML_NAS_MSD_Link".
DBCC results for 'SCU_Supported_Culture'.
There are 1 rows in 1 pages for object "SCU_Supported_Culture".
DBCC results for 'STL_String_Lookup'.
There are 10 rows in 1 pages for object "STL_String_Lookup".
DBCC results for 'UET_User_EasyTrack'.
There are 0 rows in 0 pages for object "UET_User_EasyTrack".
DBCC results for 'BC_ShiftSummaryInfo'.
Msg 8929, Level 16, State 1, Line 1
Object ID 990626572, index ID 0, partition ID 72057594045923328, alloc unit ID 72057594047627264 (type In-row data): Errors found in off-row data with ID 29856104448 owned by data record identified by RID = (1:541810:40)
Msg 8929, Level 16, State 1, Line 1
Object ID 990626572, index ID 0, partition ID 72057594045923328, alloc unit ID 72057594047627264 (type In-row data): Errors found in off-row data with ID 29856759808 owned by data record identified by RID = (1:541810:50)
Msg 8929, Level 16, State 1, Line 1
Object ID 990626572, index ID 0, partition ID 72057594045923328, alloc unit ID 72057594047627264 (type In-row data): Errors found in off-row data with ID 29854859264 owned by data record identified by RID = (1:541811:31)
Msg 8929, Level 16, State 1, Line 1
Object ID 990626572, index ID 0, partition ID 72057594045923328, alloc unit ID 72057594047627264 (type In-row data): Errors found in off-row data with ID 30184964096 owned by data record identified by RID = (1:551711:43)
Msg 2533, Level 16, State 1, Line 1
Table error: page (1:542654) allocated to object ID 990626572, index ID 0, partition ID 72057594045923328, alloc unit ID 72057594047692800 (type LOB data) was not seen. The page may be invalid or may have an incorrect alloc unit ID in its header.
Msg 8965, Level 16, State 1, Line 1
Table error: Object ID 990626572, index ID 0, partition ID 72057594045923328, alloc unit ID 72057594047692800 (type LOB data). The off-row data node at page (1:542654), slot 0, text ID 29854859264 is referenced by page (1:531974), slot 4, but was not seen in the scan.
Msg 8965, Level 16, State 1, Line 1
Table error: Object ID 990626572, index ID 0, partition ID 72057594045923328, alloc unit ID 72057594047692800 (type LOB data). The off-row data node at page (1:542654), slot 1, text ID 29856759808 is referenced by page (1:531982), slot 2, but was not seen in the scan.
Msg 8965, Level 16, State 1, Line 1
Table error: Object ID 990626572, index ID 0, partition ID 72057594045923328, alloc unit ID 72057594047692800 (type LOB data). The off-row data node at page (1:542654), slot 2, text ID 30184964096 is referenced by page (1:551711), slot 43, but was not seen in the scan.
Msg 2533, Level 16, State 1, Line 1
Table error: page (1:542686) allocated to object ID 990626572, index ID 0, partition ID 72057594045923328, alloc unit ID 72057594047692800 (type LOB data) was not seen. The page may be invalid or may have an incorrect alloc unit ID in its header.
Msg 8965, Level 16, State 1, Line 1
Table error: Object ID 990626572, index ID 0, partition ID 72057594045923328, alloc unit ID 72057594047692800 (type LOB data). The off-row data node at page (1:542686), slot 0, text ID 29856104448 is referenced by page (1:531822), slot 9, but was not seen in the scan.
Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 990626572, index ID 0, partition ID 72057594045923328, alloc unit ID 72057594047692800 (type LOB data). The off-row data node at page (1:553670), slot 18, text ID 30184964096 is not referenced.
There are 310724 rows in 2785 pages for object "BC_ShiftSummaryInfo".
CHECKDB found 0 allocation errors and 11 consistency errors in table 'BC_ShiftSummaryInfo' (object ID 990626572).
DBCC results for 'UPR_User_Preferences'.
There are 0 rows in 0 pages for object "UPR_User_Preferences".
DBCC results for 'sys.fulltext_index_docidmap_2126630619'.
There are 0 rows in 0 pages for object "sys.fulltext_index_docidmap_2126630619".
DBCC results for 'sys.fulltext_index_docidstatus_2126630619'.
There are 0 rows in 0 pages for object "sys.fulltext_index_docidstatus_2126630619".
DBCC results for 'BC_AttributeDefinition'.
There are 72 rows in 2 pages for object "BC_AttributeDefinition".
DBCC results for 'sys.fulltext_docidfilter_2126630619'.
There are 0 rows in 0 pages for object "sys.fulltext_docidfilter_2126630619".
DBCC results for 'BC_Container'.
There are 84 rows in 4 pages for object "BC_Container".
DBCC results for 'sys.fulltext_indexeddocid_2126630619'.
There are 0 rows in 0 pages for object "sys.fulltext_indexeddocid_2126630619".
DBCC results for 'BC_ContainerAttribute'.
There are 0 rows in 0 pages for object "BC_ContainerAttribute".
DBCC results for 'sys.fulltext_avdl_2126630619'.
There are 1 rows in 1 pages for object "sys.fulltext_avdl_2126630619".
DBCC results for 'BC_ContainerGroup'.
There are 198 rows in 2 pages for object "BC_ContainerGroup".
DBCC results for 'sys.fulltext_index_docidmap_91147370'.
There are 0 rows in 0 pages for object "sys.fulltext_index_docidmap_91147370".
DBCC results for 'BC_ContainerRole'.
There are 0 rows in 0 pages for object "BC_ContainerRole".
DBCC results for 'sys.fulltext_index_docidstatus_91147370'.
There are 0 rows in 0 pages for object "sys.fulltext_index_docidstatus_91147370".
DBCC results for 'BC_ShiftSummary'.
There are 16493 rows in 1139 pages for object "BC_ShiftSummary".
DBCC results for 'sys.fulltext_docidfilter_91147370'.
There are 0 rows in 0 pages for object "sys.fulltext_docidfilter_91147370".
DBCC results for 'sys.fulltext_indexeddocid_91147370'.
There are 0 rows in 0 pages for object "sys.fulltext_indexeddocid_91147370".
DBCC results for 'BC_Display'.
There are 867 rows in 72 pages for object "BC_Display".
DBCC results for 'sys.fulltext_avdl_91147370'.
There are 1 rows in 1 pages for object "sys.fulltext_avdl_91147370".
DBCC results for 'BC_DisplayAttribute'.
There are 10278 rows in 145 pages for object "BC_DisplayAttribute".
DBCC results for 'sys.fulltext_index_docidmap_155147598'.
There are 0 rows in 0 pages for object "sys.fulltext_index_docidmap_155147598".
DBCC results for 'BC_DisplayRole'.
There are 0 rows in 0 pages for object "BC_DisplayRole".
DBCC results for 'sys.fulltext_index_docidstatus_155147598'.
There are 0 rows in 0 pages for object "sys.fulltext_index_docidstatus_155147598".
DBCC results for 'BC_Group'.
There are 250 rows in 8 pages for object "BC_Group".
DBCC results for 'sys.fulltext_docidfilter_155147598'.
There are 0 rows in 0 pages for object "sys.fulltext_docidfilter_155147598".
DBCC results for 'BC_GroupRole'.
There are 0 rows in 0 pages for object "BC_GroupRole".
DBCC results for 'sys.fulltext_indexeddocid_155147598'.
There are 0 rows in 0 pages for object "sys.fulltext_indexeddocid_155147598".
DBCC results for 'BC_GroupAttribute'.
There are 0 rows in 0 pages for object "BC_GroupAttribute".
DBCC results for 'sys.fulltext_avdl_155147598'.
There are 1 rows in 1 pages for object "sys.fulltext_avdl_155147598".
DBCC results for 'BC_GroupDisplay'.
There are 2678 rows in 20 pages for object "BC_GroupDisplay".
DBCC results for 'BC_SecurityRole'.
There are 0 rows in 0 pages for object "BC_SecurityRole".
DBCC results for 'UdqProperties'.
There are 1 rows in 1 pages for object "UdqProperties".
DBCC results for 'UdqQueries'.
There are 4 rows in 1 pages for object "UdqQueries".
DBCC results for 'UdqQueryInfo'.
There are 8 rows in 3 pages for object "UdqQueryInfo".
DBCC results for 'UdqQueryParameters'.
There are 14 rows in 1 pages for object "UdqQueryParameters".
DBCC results for 'WorkcenterProperties'.
There are 1 rows in 1 pages for object "WorkcenterProperties".
DBCC results for 'EnumerationDataSources'.
There are 0 rows in 0 pages for object "EnumerationDataSources".
DBCC results for 'EnumerationMapping'.
There are 0 rows in 0 pages for object "EnumerationMapping".
DBCC results for 'EnumerationStates'.
There are 0 rows in 0 pages for object "EnumerationStates".
DBCC results for 'Enumerations'.
There are 0 rows in 0 pages for object "Enumerations".
DBCC results for 'EnumerationBulkLoadCommands'.
There are 0 rows in 0 pages for object "EnumerationBulkLoadCommands".
DBCC results for 'EnumerationBulkLoadErrors'.
There are 0 rows in 0 pages for object "EnumerationBulkLoadErrors".
DBCC results for 'EnumerationChanges'.
There are 0 rows in 0 pages for object "EnumerationChanges".
DBCC results for 'IntervalDefinitions'.
There are 7 rows in 1 pages for object "IntervalDefinitions".
DBCC results for 'DUAL'.
There are 1 rows in 1 pages for object "DUAL".
DBCC results for 'BC_SSTableEntry'.
There are 606 rows in 356 pages for object "BC_SSTableEntry".
DBCC results for 'TempRawEnumMappings'.
There are 0 rows in 0 pages for object "TempRawEnumMappings".
DBCC results for 'TempRawEnumTypes'.
There are 0 rows in 0 pages for object "TempRawEnumTypes".
DBCC results for 'sys.queue_messages_1977058079'.
There are 0 rows in 0 pages for object "sys.queue_messages_1977058079".
DBCC results for 'sys.queue_messages_2009058193'.
There are 0 rows in 0 pages for object "sys.queue_messages_2009058193".
DBCC results for 'sys.queue_messages_2041058307'.
There are 0 rows in 0 pages for object "sys.queue_messages_2041058307".
DBCC results for 'sys.filestream_tombstone_2073058421'.
There are 0 rows in 0 pages for object "sys.filestream_tombstone_2073058421".
DBCC results for 'sys.syscommittab'.
There are 0 rows in 0 pages for object "sys.syscommittab".
DBCC results for 'TableAlphanumericDataItem'.
There are 0 rows in 0 pages for object "TableAlphanumericDataItem".
DBCC results for 'IP_EQ'.
There are 5147 rows in 49 pages for object "IP_EQ".
DBCC results for 'BC_Package'.
There are 11 rows in 1 pages for object "BC_Package".
DBCC results for 'TableBreakpoint'.
There are 0 rows in 0 pages for object "TableBreakpoint".
DBCC results for 'OM_EQUIP_LINKS'.
There are 25620 rows in 194 pages for object "OM_EQUIP_LINKS".
DBCC results for 'TableCell'.
There are 0 rows in 0 pages for object "TableCell".
DBCC results for 'BC_LookupType'.
There are 8 rows in 1 pages for object "BC_LookupType".
DBCC results for 'TableCellColumnLocation'.
There are 0 rows in 0 pages for object "TableCellColumnLocation".
CHECKDB found 0 allocation errors and 13 consistency errors in database 'BaseComponents'.
repair_allow_data_loss is the minimum repair level for the errors found by DBCC CHECKDB (BaseComponents).
DBCC execution completed. If DBCC printed error messages, contact your system administrator.

Thanks
ananda
Post #1397709
Posted Tuesday, December 18, 2012 5:15 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: Yesterday @ 11:52 AM
Points: 41,530, Visits: 34,446
Restore from a clean backup.


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 #1397711
Posted Tuesday, December 18, 2012 5:29 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Wednesday, April 16, 2014 11:56 PM
Points: 1,015, Visits: 2,840
Thanks for reply ...

I have last 5 days backup file....But user side they want current data as on date today...If restored Last day backup today data will not be available? please suggestion me how to aviod this data loss?
Post #1397716
Posted Tuesday, December 18, 2012 5:35 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Wednesday, August 28, 2013 2:37 AM
Points: 5,075, Visits: 4,834
Do you have transaction log backups? Do you know when the corruption happened?



Want an answer fast? Try here
How to post data/code for the best help - Jeff Moden
Need a string splitter, try this - Jeff Moden
How to post performance problems - Gail Shaw
CrossTabs-Part1 & Part2 - Jeff Moden
SQL Server Backup, Integrity Check, and Index and Statistics Maintenance - Ola Hallengren
Managing Transaction Logs - Gail Shaw
Troubleshooting SQL Server: A Guide for the Accidental DBA - Jonathan Kehayias and Ted Krueger

Post #1397718
Posted Tuesday, December 18, 2012 5:36 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: Yesterday @ 11:52 AM
Points: 41,530, Visits: 34,446
If you repair, you will lose data.

If you want to avoid data loss, then you need to take a tail-log backup, restore the last clean full backup and all log backups since then.



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 #1397719
Posted Tuesday, December 18, 2012 5:45 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Wednesday, April 16, 2014 11:56 PM
Points: 1,015, Visits: 2,840

I came to know database backup failed due to cycle error for reading MDF file...

I thing the only way to Run dbcc repaire_allow_data_loss command, Becuase I do not have Tlog backup also database is SIMPLE recovery mode...

If Ran this command how much data will be loss, per day or any time period?
Post #1397725
Posted Tuesday, December 18, 2012 6:00 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: Yesterday @ 11:52 AM
Points: 41,530, Visits: 34,446
I recommend restoring from the last good full backup. Since the DB is in simple recovery model, that amount of data loss (since the last full backup) must be acceptable to the business.


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 #1397733
Posted Tuesday, December 18, 2012 6:21 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Yesterday @ 12:01 PM
Points: 12,744, Visits: 31,074
GilaMonster (12/18/2012)
I recommend restoring from the last good full backup. Since the DB is in simple recovery model, that amount of data loss (since the last full backup) must be acceptable to the business.


uggh...that's a hard recommendation for me to want to think about.

i think i'd recommend renaming the current database, and restoring the last full backup as the original.

at least then you can compare tables database to database and try to identify any data they might want to keep.

This is more of an accidental issue (poor backup plan, unexpected error) than a knowledgeable decision that the business knows it can sustain a data loss for a whole weeks worth of changes.


Lowell

--There is no spoon, and there's no default ORDER BY in sql server either.
Actually, Common Sense is so rare, it should be considered a Superpower. --my son
Post #1397748
Posted Tuesday, December 18, 2012 6:36 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: Yesterday @ 11:52 AM
Points: 41,530, Visits: 34,446
Lowell (12/18/2012)
GilaMonster (12/18/2012)
I recommend restoring from the last good full backup. Since the DB is in simple recovery model, that amount of data loss (since the last full backup) must be acceptable to the business.


uggh...that's a hard recommendation for me to want to think about.


Data will be lost in this scenario.

The options are to restore back to the last full backup and have a database that's transactionally consistent as of a known time, resulting in one day of data loss, or repair and have a database that may be transactionally inconsistent with an unknown amount of data loss. That's pretty much the options that are left at this point



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 #1397759
Posted Tuesday, December 18, 2012 10:16 PM


SSC-Enthusiastic

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

Group: General Forum Members
Last Login: Monday, April 14, 2014 12:44 AM
Points: 102, Visits: 1,165
Restore from backup is the best solution to repair database.

You can also try third party SQL Recovery Software to repair your database. You can search these software on Google.


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

Add to briefcase 12»»

Permissions Expand / Collapse