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

SQLDUMPER_ERRORLOG and Index courrpted? Expand / Collapse
Author
Message
Posted Tuesday, March 18, 2014 4:52 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Yesterday @ 11:41 PM
Points: 1,058, Visits: 2,991

due to constraint not able to delete that index.

First drop that Uniqe key constraint and then it will allow drop that index..

Pls. confirm if drop constaint key if any impact on that table..

Post #1552099
Posted Tuesday, March 18, 2014 4:59 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 @ 12:33 PM
Points: 42,818, Visits: 35,943
What kind of 'impact'?
You are going to recreate the unique constraint immediately?



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 #1552100
Posted Tuesday, March 18, 2014 5:09 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Yesterday @ 11:41 PM
Points: 1,058, Visits: 2,991
yes, immediate i will recreate constraint. drop and recreate it will take 2 0r 3 min times.
Post #1552104
Posted Tuesday, March 18, 2014 5:19 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Yesterday @ 11:41 PM
Points: 1,058, Visits: 2,991
Thank you so much for your help.. I have done successfully all the action.

DBCC CHECKDB ([Honeywell.MES.LimitRepository.DataModel.LRModel]) WITH NO_INFOMSGS, ALL_ERRORMSGS;

Command(s) completed successfully.

Post #1552108
Posted Tuesday, March 18, 2014 5:52 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Yesterday @ 11:41 PM
Points: 1,058, Visits: 2,991

one more help.. as per attached SQLDumper log, is it missing patch level on SP3? Pls. confirm

current version

Microsoft SQL Server 2008 (SP3) - 10.0.5500.0 (Intel X86) Sep 22 2011 00:28:06 Copyright (c) 1988-2008 Microsoft Corporation Enterprise Edition on Windows NT 6.0 <X86> (Build 6002: Service Pack 2)

Thanks
ananda
Post #1552118
Posted Tuesday, March 18, 2014 6:43 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 @ 12:33 PM
Points: 42,818, Visits: 35,943
Um...

ananda.murugesan (3/18/2014)

current version

Microsoft SQL Server 2008 (SP3) - 10.0.5500.0 (Intel X86) Sep 22 2011 00:28:06





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

Add to briefcase ««12

Permissions Expand / Collapse