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

Dbcc checkdb command Expand / Collapse
Author
Message
Posted Thursday, June 20, 2013 1:23 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Friday, July 11, 2014 1:25 PM
Points: 83, Visits: 447
Dear Sir,

Here i am having a doubt

When we run DBCC CHECKDB command if we found any error we can fix them by using repair_fat,Repair_rebuild,Repair_allow_data_loss.

If application team not ready for data loss we will restore the backup.if they are not ready to restore the backup also is there any another method to fix this issue.
Post #1465486
Posted Thursday, June 20, 2013 1:56 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 @ 4:54 PM
Points: 42,434, Visits: 35,488
Repair is usually the last option for when there's no good backup.
http://www.sqlservercentral.com/articles/Corruption/65804/



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 #1465495
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse