Resoring SQL SERVER without Backup

Question

Post reply

Resoring SQL SERVER without Backup

hsac1301

SSC Veteran

Points: 212
More actions
September 16, 2009 at 7:40 am

#385374

Hi,
I have SQL 2005 server and because of the power failure, The databse has been corrupted. I have no backup at all.
I have tried
exec sp_resetstatus 'Net'
alter database Net SET EMERGENCY
DBCC CheckDB('net')
alter Database Net SET SINGLE_USER WITH ROLLBACK IMMEDIATE
dbcc CheckDB ('Net',REPAIR_ALLOW_DATA_LOSS)
alter Database Net SET MULTI_USER
But after 15 mins i got an error, Failed to recover so pls recover from Backup.
Please advise how can i recover it without backup.
Thanks
Hsac

Viewing 7 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply

homebrew01 SSC Guru Points: 55553 More actions · Answer 1

Have you done a clean reboot of the server ?

And why is there no backup ? Are your other databases backed up ?

Grant Fritchey SSC Guru Points: 399278 More actions · Answer 2

hsac1301 (9/16/2009)
Hi,
I have SQL 2005 server and because of the power failure, The databse has been corrupted. I have no backup at all.
I have tried
exec sp_resetstatus 'Net'
alter database Net SET EMERGENCY
DBCC CheckDB('net')
alter Database Net SET SINGLE_USER WITH ROLLBACK IMMEDIATE
dbcc CheckDB ('Net',REPAIR_ALLOW_DATA_LOSS)
alter Database Net SET MULTI_USER
But after 15 mins i got an error, Failed to recover so pls recover from Backup.
Please advise how can i recover it without backup.
Thanks
Hsac

I would NEVER recommend running CHECKDB with REPAIR_ALLOW_DATA_LOSS, but if you ran that and it didn't come back, you're pretty much in a world of hurt now. You don't haven any backups at all? Do you at least have the scripts to recreate the database structures?

You might go over & start reading Paul Randal's site. I'd especially recommend this series of articles.

Oh, and get backups running on all your production systems, right away.

"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt

Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning

hsac1301 SSC Veteran Points: 212 More actions · Answer 3

Thanks

Is there any way to recover

.I have used the following:

exec sp_resetstatus 'Netperf'

alter database Netperf SET EMERGENCY

DBCC CheckDB('netperf')

alter Database Netperf SET SINGLE_USER WITH ROLLBACK IMMEDIATE

dbcc CheckDB ('Netperf',REPAIR_ALLOW_DATA_LOSS)

alter Database Netperf SET MULTI_USER

I have got the following errors:

The suspect flag on the database "Netperf" is already reset.

DBCC results for 'NetPerf'.

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.

DBCC results for 'sys.sysrowsetcolumns'.

There are 2477 rows in 19 pages for object "sys.sysrowsetcolumns".

DBCC results for 'sys.sysrowsets'.

There are 305 rows in 2 pages for object "sys.sysrowsets".

DBCC results for 'sysallocunits'.

There are 336 rows in 4 pages for object "sysallocunits".

DBCC results for 'sys.sysfiles1'.

There are 2 rows in 1 pages for object "sys.sysfiles1".

DBCC results for 'sys.syshobtcolumns'.

There are 2477 rows in 19 pages for object "sys.syshobtcolumns".

DBCC results for 'sys.syshobts'.

There are 305 rows in 2 pages for object "sys.syshobts".

DBCC results for 'sys.sysftinds'.

There are 0 rows in 0 pages for object "sys.sysftinds".

DBCC results for 'sys.sysserefs'.

There are 336 rows in 3 pages for object "sys.sysserefs".

DBCC results for 'sys.sysowners'.

There are 16 rows in 1 pages for object "sys.sysowners".

DBCC results for 'sys.sysprivs'.

There are 122 rows in 1 pages for object "sys.sysprivs".

DBCC results for 'sys.sysschobjs'.

There are 814 rows in 14 pages for object "sys.sysschobjs".

DBCC results for 'sys.syscolpars'.

There are 2854 rows in 57 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 27 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 860 rows in 18 pages for object "sys.sysidxstats".

DBCC results for 'sys.sysiscols'.

There are 1088 rows in 6 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.sysobjvalues'.

There are 1325 rows in 379 pages for object "sys.sysobjvalues".

DBCC results for 'sys.sysclsobjs'.

There are 15 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 134 rows in 1 pages for object "sys.syssingleobjrefs".

DBCC results for 'sys.sysmultiobjrefs'.

There are 1935 rows in 22 pages for object "sys.sysmultiobjrefs".

DBCC results for 'sys.sysdbfiles'.

There are 2 rows in 1 pages for object "sys.sysdbfiles".

DBCC results for 'sys.sysguidrefs'.

There are 0 rows in 0 pages for object "sys.sysguidrefs".

DBCC results for 'sys.sysqnames'.

There are 91 rows in 1 pages for object "sys.sysqnames".

DBCC results for 'sys.sysxmlcomponent'.

There are 93 rows in 1 pages for object "sys.sysxmlcomponent".

DBCC results for 'sys.sysxmlfacet'.

There are 97 rows in 1 pages for object "sys.sysxmlfacet".

DBCC results for 'sys.sysxmlplacement'.

There are 17 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 0 rows in 0 pages for object "sys.sysbinsubobjs".

DBCC results for 'APM_Application'.

There are 14 rows in 1 pages for object "APM_Application".

DBCC results for 'VMStatistics_Daily'.

There are 0 rows in 0 pages for object "VMStatistics_Daily".

DBCC results for 'WebSettings'.

There are 18 rows in 1 pages for object "WebSettings".

DBCC results for 'AlertActions'.

There are 0 rows in 0 pages for object "AlertActions".

DBCC results for 'APM_ApplicationStatus_Daily'.

There are 590 rows in 4 pages for object "APM_ApplicationStatus_Daily".

DBCC results for 'VMStatistics_Detail'.

There are 0 rows in 0 pages for object "VMStatistics_Detail".

DBCC results for 'ActionDefinitions'.

There are 66 rows in 4 pages for object "ActionDefinitions".

DBCC results for 'Alerts'.

There are 9 rows in 1 pages for object "Alerts".

DBCC results for 'VMStatistics_Hourly'.

There are 0 rows in 0 pages for object "VMStatistics_Hourly".

DBCC results for 'APM_ApplicationStatus_Detail'.

Msg 8952, Level 16, State 1, Line 5

Table error: table 'APM_ApplicationStatus_Detail' (ID 87671360). Index row in index 'IX_APM_ApplicationStatus_Detail_TimeStamp' (ID 2) does not match any data row. Possible extra or invalid keys for:

Msg 8956, Level 16, State 1, Line 5

Index row (1:3791:0) with values (Timestamp = '2009-09-16 01:50:28.220' and ApplicationID = 13 and Archive = 0) pointing to the data row identified by (ApplicationID = 13 and Timestamp = '2009-09-16 01:50:28.220' and Archive = 0).

Msg 8952, Level 16, State 1, Line 5

Table error: table 'APM_ApplicationStatus_Detail' (ID 87671360). Index row in index 'IX_APM_ApplicationStatus_Detail_TimeStamp' (ID 2) does not match any data row. Possible extra or invalid keys for:

Msg 8956, Level 16, State 1, Line 5

Index row (1:3791:1) with values (Timestamp = '2009-09-16 01:49:54.093' and ApplicationID = 16 and Archive = 0) pointing to the data row identified by (ApplicationID = 16 and Timestamp = '2009-09-16 01:49:54.093' and Archive = 0).

Msg 8952, Level 16, State 1, Line 5

Table error: table 'APM_ApplicationStatus_Detail' (ID 87671360). Index row in index 'IX_APM_ApplicationStatus_Detail_TimeStamp' (ID 2) does not match any data row. Possible extra or invalid keys for:

Msg 8956, Level 16, State 1, Line 5

Index row (1:3791:2) with values (Timestamp = '2009-09-16 01:49:54.000' and ApplicationID = 16 and Archive = 0) pointing to the data row identified by (ApplicationID = 16 and Timestamp = '2009-09-16 01:49:54.000' and Archive = 0).

Msg 8952, Level 16, State 1, Line 5

Table error: table 'APM_ApplicationStatus_Detail' (ID 87671360). Index row in index 'IX_APM_ApplicationStatus_Detail_TimeStamp' (ID 2) does not match any data row. Possible extra or invalid keys for:

Msg 8956, Level 16, State 1, Line 5

Index row (1:3791:3) with values (Timestamp = '2009-09-16 01:49:53.970' and ApplicationID = 16 and Archive = 0) pointing to the data row identified by (ApplicationID = 16 and Timestamp = '2009-09-16 01:49:53.970' and Archive = 0).

Msg 8952, Level 16, State 1, Line 5

Table error: table 'APM_ApplicationStatus_Detail' (ID 87671360). Index row in index 'IX_APM_ApplicationStatus_Detail_TimeStamp' (ID 2) does not match any data row. Possible extra or invalid keys for:

Msg 8956, Level 16, State 1, Line 5

Index row (1:3791:4) with values (Timestamp = '2009-09-16 01:49:53.937' and ApplicationID = 16 and Archive = 0) pointing to the data row identified by (ApplicationID = 16 and Timestamp = '2009-09-16 01:49:53.937' and Archive = 0).

Msg 8952, Level 16, State 1, Line 5

Table error: table 'APM_ApplicationStatus_Detail' (ID 87671360). Index row in index 'IX_APM_ApplicationStatus_Detail_TimeStamp' (ID 2) does not match any data row. Possible extra or invalid keys for:

Msg 8956, Level 16, State 1, Line 5

Index row (1:3791:5) with values (Timestamp = '2009-09-16 01:49:53.843' and ApplicationID = 15 and Archive = 0) pointing to the data row identified by (ApplicationID = 15 and Timestamp = '2009-09-16 01:49:53.843' and Archive = 0).

Msg 8952, Level 16, State 1, Line 5

Table error: table 'APM_ApplicationStatus_Detail' (ID 87671360). Index row in index 'IX_APM_ApplicationStatus_Detail_TimeStamp' (ID 2) does not match any data row. Possible extra or invalid keys for:

Msg 8956, Level 16, State 1, Line 5

Index row (1:3791:6) with values (Timestamp = '2009-09-16 01:49:53.813' and ApplicationID = 15 and Archive = 0) pointing to the data row identified by (ApplicationID = 15 and Timestamp = '2009-09-16 01:49:53.813' and Archive = 0).

Msg 8952, Level 16, State 1, Line 5

Table error: table 'APM_ApplicationStatus_Detail' (ID 87671360). Index row in index 'IX_APM_ApplicationStatus_Detail_TimeStamp' (ID 2) does not match any data row. Possible extra or invalid keys for:

Msg 8956, Level 16, State 1, Line 5

Index row (1:3791:7) with values (Timestamp = '2009-09-16 01:49:53.720' and ApplicationID = 15 and Archive = 0) pointing to the data row identified by (ApplicationID = 15 and Timestamp = '2009-09-16 01:49:53.720' and Archive = 0).

Msg 8952, Level 16, State 1, Line 5

Table error: table 'APM_ApplicationStatus_Detail' (ID 87671360). Index row in index 'IX_APM_ApplicationStatus_Detail_TimeStamp' (ID 2) does not match any data row. Possible extra or invalid keys for:

Msg 8956, Level 16, State 1, Line 5

Index row (1:3791:8) with values (Timestamp = '2009-09-16 01:49:53.687' and ApplicationID = 15 and Archive = 0) pointing to the data row identified by (ApplicationID = 15 and Timestamp = '2009-09-16 01:49:53.687' and Archive = 0).

Msg 8952, Level 16, State 1, Line 5

Table error: table 'APM_ApplicationStatus_Detail' (ID 87671360). Index row in index 'IX_APM_ApplicationStatus_Detail_TimeStamp' (ID 2) does not match any data row. Possible extra or invalid keys for:

Msg 8956, Level 16, State 1, Line 5

Index row (1:3791:9) with values (Timestamp = '2009-09-16 01:49:53.657' and ApplicationID = 15 and Archive = 0) pointing to the data row identified by (ApplicationID = 15 and Timestamp = '2009-09-16 01:49:53.657' and Archive = 0).

Msg 8952, Level 16, State 1, Line 5

Table error: table 'APM_ApplicationStatus_Detail' (ID 87671360). Index row in index 'IX_APM_ApplicationStatus_Detail_TimeStamp' (ID 2) does not match any data row. Possible extra or invalid keys for:

Msg 8956, Level 16, State 1, Line 5

Index row (1:3791:10) with values (Timestamp = '2009-09-16 01:49:53.627' and ApplicationID = 15 and Archive = 0) pointing to the data row identified by (ApplicationID = 15 and Timestamp = '2009-09-16 01:49:53.627' and Archive = 0).

Msg 8952, Level 16, State 1, Line 5

Table error: table 'APM_ApplicationStatus_Detail' (ID 87671360). Index row in index 'IX_APM_ApplicationStatus_Detail_TimeStamp' (ID 2) does not match any data row. Possible extra or invalid keys for:

Msg 8956, Level 16, State 1, Line 5

Index row (1:3791:11) with values (Timestamp = '2009-09-16 01:49:53.593' and ApplicationID = 15 and Archive = 0) pointing to the data row identified by (ApplicationID = 15 and Timestamp = '2009-09-16 01:49:53.593' and Archive = 0).

Msg 8952, Level 16, State 1, Line 5

Table error: table 'APM_ApplicationStatus_Detail' (ID 87671360). Index row in index 'IX_APM_ApplicationStatus_Detail_TimeStamp' (ID 2) does not match any data row. Possible extra or invalid keys for:

Msg 8956, Level 16, State 1, Line 5

Index row (1:3791:12) with values (Timestamp = '2009-09-16 01:49:53.563' and ApplicationID = 15 and Archive = 0) pointing to the data row identified by (ApplicationID = 15 and Timestamp = '2009-09-16 01:49:53.563' and Archive = 0).

Msg 8952, Level 16, State 1, Line 5

Table error: table 'APM_ApplicationStatus_Detail' (ID 87671360). Index row in index 'IX_APM_ApplicationStatus_Detail_TimeStamp' (ID 2) does not match any data row. Possible extra or invalid keys for:

Msg 8956, Level 16, State 1, Line 5

Index row (1:3791:13) with values (Timestamp = '2009-09-16 01:49:53.470' and ApplicationID = 15 and Archive = 0) pointing to the data row identified by (ApplicationID = 15 and Timestamp = '2009-09-16 01:49:53.470' and Archive = 0).

Msg 8952, Level 16, State 1, Line 5

Table error: table 'APM_ApplicationStatus_Detail' (ID 87671360). Index row in index 'IX_APM_ApplicationStatus_Detail_TimeStamp' (ID 2) does not match any data row. Possible extra or invalid keys for:

Msg 8956, Level 16, State 1, Line 5

Index row (1:3791:14) with values (Timestamp = '2009-09-16 01:49:53.377' and ApplicationID = 15 and Archive = 0) pointing to the data row identified by (ApplicationID = 15 and Timestamp = '2009-09-16 01:49:53.377' and Archive = 0).

Msg 8952, Level 16, State 1, Line 5

Table error: table 'APM_ApplicationStatus_Detail' (ID 87671360). Index row in index 'IX_APM_ApplicationStatus_Detail_TimeStamp' (ID 2) does not match any data row. Possible extra or invalid keys for:

Msg 8956, Level 16, State 1, Line 5

Index row (1:3791:15) with values (Timestamp = '2009-09-16 01:49:53.343' and ApplicationID = 15 and Archive = 0) pointing to the data row identified by (ApplicationID = 15 and Timestamp = '2009-09-16 01:49:53.343' and Archive = 0).

Msg 8952, Level 16, State 1, Line 5

Table error: table 'APM_ApplicationStatus_Detail' (ID 87671360). Index row in index 'IX_APM_ApplicationStatus_Detail_TimeStamp' (ID 2) does not match any data row. Possible extra or invalid keys for:

Msg 8956, Level 16, State 1, Line 5

Index row (1:3791:16) with values (Timestamp = '2009-09-16 01:49:53.250' and ApplicationID = 15 and Archive = 0) pointing to the data row identified by (ApplicationID = 15 and Timestamp = '2009-09-16 01:49:53.250' and Archive = 0).

Msg 8952, Level 16, State 1, Line 5

Table error: table 'APM_ApplicationStatus_Detail' (ID 87671360). Index row in index 'IX_APM_ApplicationStatus_Detail_TimeStamp' (ID 2) does not match any data row. Possible extra or invalid keys for:

Msg 8956, Level 16, State 1, Line 5

Index row (1:3791:17) with values (Timestamp = '2009-09-16 01:49:53.093' and ApplicationID = 15 and Archive = 0) pointing to the data row identified by (ApplicationID = 15 and Timestamp = '2009-09-16 01:49:53.093' and Archive = 0).

Msg 8952, Level 16, State 1, Line 5

Table error: table 'APM_ApplicationStatus_Detail' (ID 87671360). Index row in index 'IX_APM_ApplicationStatus_Detail_TimeStamp' (ID 2) does not match any data row. Possible extra or invalid keys for:

Msg 8956, Level 16, State 1, Line 5

Index row (1:3791:18) with values (Timestamp = '2009-09-16 01:49:52.877' and ApplicationID = 15 and Archive = 0) pointing to the data row identified by (ApplicationID = 15 and Timestamp = '2009-09-16 01:49:52.877' and Archive = 0).

Msg 8952, Level 16, State 1, Line 5

Table error: table 'APM_ApplicationStatus_Detail' (ID 87671360). Index row in index 'IX_APM_ApplicationStatus_Detail_TimeStamp' (ID 2) does not match any data row. Possible extra or invalid keys for:

Msg 8956, Level 16, State 1, Line 5

Index row (1:3791:19) with values (Timestamp = '2009-09-16 01:49:52.827' and ApplicationID = 15 and Archive = 0) pointing to the data row identified by (ApplicationID = 15 and Timestamp = '2009-09-16 01:49:52.827' and Archive = 0).

Msg 8952, Level 16, State 1, Line 5

Table error: table 'APM_ApplicationStatus_Detail' (ID 87671360). Index row in index 'IX_APM_ApplicationStatus_Detail_TimeStamp' (ID 2) does not match any data row. Possible extra or invalid keys for:

Msg 8956, Level 16, State 1, Line 5

Index row (1:3791:20) with values (Timestamp = '2009-09-16 01:49:52.797' and ApplicationID = 15 and Archive = 0) pointing to the data row identified by (ApplicationID = 15 and Timestamp = '2009-09-16 01:49:52.797' and Archive = 0).

Msg 8952, Level 16, State 1, Line 5

Table error: table 'APM_ApplicationStatus_Detail' (ID 87671360). Index row in index 'IX_APM_ApplicationStatus_Detail_TimeStamp' (ID 2) does not match any data row. Possible extra or invalid keys for:

Msg 8956, Level 16, State 1, Line 5

Index row (1:3791:21) with values (Timestamp = '2009-09-16 01:49:52.703' and ApplicationID = 15 and Archive = 0) pointing to the data row identified by (ApplicationID = 15 and Timestamp = '2009-09-16 01:49:52.703' and Archive = 0).

There are 92815 rows in 700 pages for object "APM_ApplicationStatus_Detail".

CHECKDB found 0 allocation errors and 22 consistency errors in table 'APM_ApplicationStatus_Detail' (object ID 87671360).

DBCC results for 'VolumeUsage_Daily'.

There are 2400 rows in 38 pages for object "VolumeUsage_Daily".

DBCC results for 'Traps'.

There are 628 rows in 15 pages for object "Traps".

DBCC results for 'APM_ApplicationStatus_Hourly'.

There are 5802 rows in 59 pages for object "APM_ApplicationStatus_Hourly".

DBCC results for 'AlertSuppression'.

There are 0 rows in 0 pages for object "AlertSuppression".

DBCC results for 'APM_ApplicationsToDelete'.

There are 0 rows in 0 pages for object "APM_ApplicationsToDelete".

DBCC results for 'APM_ApplicationTemplate'.

There are 27 rows in 1 pages for object "APM_ApplicationTemplate".

DBCC results for 'CustomPollerLabels'.

There are 0 rows in 0 pages for object "CustomPollerLabels".

DBCC results for 'APM_BusinessLayer'.

There are 1 rows in 1 pages for object "APM_BusinessLayer".

DBCC results for 'AlertDefinitions'.

There are 29 rows in 2 pages for object "AlertDefinitions".

DBCC results for 'CustomPollerAssignment'.

There are 0 rows in 0 pages for object "CustomPollerAssignment".

DBCC results for 'TrapVarbinds'.

There are 12559 rows in 153 pages for object "TrapVarbinds".

DBCC results for 'APM_Component'.

There are 87 rows in 2 pages for object "APM_Component".

DBCC results for 'VolumeUsage_Detail'.

There are 150289 rows in 1442 pages for object "VolumeUsage_Detail".

DBCC results for 'APM_ComponentDataToDelete'.

There are 0 rows in 1 pages for object "APM_ComponentDataToDelete".

DBCC results for 'AlertTriggerMap'.

There are 19 rows in 278 pages for object "AlertTriggerMap".

DBCC results for 'CustomPollerEnums'.

There are 3 rows in 1 pages for object "CustomPollerEnums".

DBCC results for 'APM_ComponentDefinition'.

There are 20 rows in 1 pages for object "APM_ComponentDefinition".

DBCC results for 'AlertValueChanges'.

There are 0 rows in 1 pages for object "AlertValueChanges".

DBCC results for 'CustomPollerParsers'.

There are 19 rows in 1 pages for object "CustomPollerParsers".

DBCC results for 'APM_ComponentDefinitionCategory'.

There are 4 rows in 1 pages for object "APM_ComponentDefinitionCategory".

DBCC results for 'APM_ComponentDefinitionCategoryMembership'.

There are 49 rows in 1 pages for object "APM_ComponentDefinitionCategoryMembership".

DBCC results for 'CiscoBuffers_Daily'.

There are 6922 rows in 56 pages for object "CiscoBuffers_Daily".

DBCC results for 'APM_ComponentDefinitionSetting'.

There are 114 rows in 1 pages for object "APM_ComponentDefinitionSetting".

DBCC results for 'CustomPollers'.

There are 10 rows in 1 pages for object "CustomPollers".

DBCC results for 'APM_ComponentSetting'.

There are 0 rows in 0 pages for object "APM_ComponentSetting".

DBCC results for 'VolumeUsage_Hourly'.

There are 87988 rows in 1093 pages for object "VolumeUsage_Hourly".

DBCC results for 'FlowCorrelation'.

Msg 8951, Level 16, State 1, Line 5

Table error: table 'FlowCorrelation' (ID 468196718). Data row does not have a matching index row in the index 'IX_Domain' (ID 2). Possible missing or invalid keys for the index row matching:

Msg 8955, Level 16, State 1, Line 5

Data row (1:6962:26) identified by (IPAddressSort = 1.182082151890000e+011) with index values 'Domain = '' and IPAddressSort = 1.182082151890000e+011'.

Msg 8951, Level 16, State 1, Line 5

Table error: table 'FlowCorrelation' (ID 468196718). Data row does not have a matching index row in the index 'IX_Domain' (ID 2). Possible missing or invalid keys for the index row matching:

Msg 8955, Level 16, State 1, Line 5

Data row (1:6962:31) identified by (IPAddressSort = 1.182082152490000e+011) with index values 'Domain = '' and IPAddressSort = 1.182082152490000e+011'.

Msg 8951, Level 16, State 1, Line 5

Table error: table 'FlowCorrelation' (ID 468196718). Data row does not have a matching index row in the index 'IX_Domain' (ID 2). Possible missing or invalid keys for the index row matching:

Msg 8955, Level 16, State 1, Line 5

Data row (1:44010:29) identified by (IPAddressSort = 1.190730321450000e+011) with index values 'Domain = '' and IPAddressSort = 1.190730321450000e+011'.

Msg 8951, Level 16, State 1, Line 5

Table error: table 'FlowCorrelation' (ID 468196718). Data row does not have a matching index row in the index 'IX_Domain' (ID 2). Possible missing or invalid keys for the index row matching:

Msg 8955, Level 16, State 1, Line 5

Data row (1:159256:40) identified by (IPAddressSort = 1.591530990300000e+011) with index values 'Domain = '' and IPAddressSort = 1.591530990300000e+011'.

Msg 8951, Level 16, State 1, Line 5

Table error: table 'FlowCorrelation' (ID 468196718). Data row does not have a matching index row in the index 'IX_Domain' (ID 2). Possible missing or invalid keys for the index row matching:

Msg 8955, Level 16, State 1, Line 5

Data row (1:163992:20) identified by (IPAddressSort = 1.221641460840000e+011) with index values 'Domain = '' and IPAddressSort = 1.221641460840000e+011'.

Msg 8951, Level 16, State 1, Line 5

Table error: table 'FlowCorrelation' (ID 468196718). Data row does not have a matching index row in the index 'IX_Domain' (ID 2). Possible missing or invalid keys for the index row matching:

Msg 8955, Level 16, State 1, Line 5

Data row (1:268038:0) identified by (IPAddressSort = 1.182081442110000e+011) with index values 'Domain = '' and IPAddressSort = 1.182081442110000e+011'.

Msg 8951, Level 16, State 1, Line 5

Table error: table 'FlowCorrelation' (ID 468196718). Data row does not have a matching index row in the index 'IX_Domain' (ID 2). Possible missing or invalid keys for the index row matching:

Msg 8955, Level 16, State 1, Line 5

Data row (1:294510:1) identified by (IPAddressSort = 1.221211591490000e+011) with index values 'Domain = '' and IPAddressSort = 1.221211591490000e+011'.

Msg 8951, Level 16, State 1, Line 5

Table error: table 'FlowCorrelation' (ID 468196718). Data row does not have a matching index row in the index 'IX_Domain' (ID 2). Possible missing or invalid keys for the index row matching:

Msg 8955, Level 16, State 1, Line 5

Data row (1:298356:25) identified by (IPAddressSort = 1.182082441390000e+011) with index values 'Domain = '' and IPAddressSort = 1.182082441390000e+011'.

Msg 8951, Level 16, State 1, Line 5

Table error: table 'FlowCorrelation' (ID 468196718). Data row does not have a matching index row in the index 'IX_Domain' (ID 2). Possible missing or invalid keys for the index row matching:

Msg 8955, Level 16, State 1, Line 5

Data row (1:337608:37) identified by (IPAddressSort = 1.182080070420000e+011) with index values 'Domain = '' and IPAddressSort = 1.182080070420000e+011'.

Msg 8951, Level 16, State 1, Line 5

Table error: table 'FlowCorrelation' (ID 468196718). Data row does not have a matching index row in the index 'IX_Domain' (ID 2). Possible missing or invalid keys for the index row matching:

Msg 8955, Level 16, State 1, Line 5

Data row (1:368699:2) identified by (IPAddressSort = 1.231250660210000e+011) with index values 'Domain = '' and IPAddressSort = 1.231250660210000e+011'.

Msg 8951, Level 16, State 1, Line 5

Table error: table 'FlowCorrelation' (ID 468196718). Data row does not have a matching index row in the index 'IX_Domain' (ID 2). Possible missing or invalid keys for the index row matching:

Msg 8955, Level 16, State 1, Line 5

Data row (1:454719:11) identified by (IPAddressSort = 1.221670951790000e+011) with index values 'Domain = '' and IPAddressSort = 1.221670951790000e+011'.

Msg 8951, Level 16, State 1, Line 5

Table error: table 'FlowCorrelation' (ID 468196718). Data row does not have a matching index row in the index 'IX_Domain' (ID 2). Possible missing or invalid keys for the index row matching:

Msg 8955, Level 16, State 1, Line 5

Data row (1:537058:38) identified by (IPAddressSort = 1.182080181030000e+011) with index values 'Domain = '' and IPAddressSort = 1.182080181030000e+011'.

Msg 8951, Level 16, State 1, Line 5

Table error: table 'FlowCorrelation' (ID 468196718). Data row does not have a matching index row in the index 'IX_Domain' (ID 2). Possible missing or invalid keys for the index row matching:

Msg 8955, Level 16, State 1, Line 5

Data row (1:619039:8) identified by (IPAddressSort = 1.190730321800000e+011) with index values 'Domain = '' and IPAddressSort = 1.190730321800000e+011'.

Msg 8951, Level 16, State 1, Line 5

Table error: table 'FlowCorrelation' (ID 468196718). Data row does not have a matching index row in the index 'IX_Domain' (ID 2). Possible missing or invalid keys for the index row matching:

Msg 8955, Level 16, State 1, Line 5

Data row (1:670666:56) identified by (IPAddressSort = 1.190631770180000e+011) with index values 'Domain = '' and IPAddressSort = 1.190631770180000e+011'.

Msg 8951, Level 16, State 1, Line 5

Table error: table 'FlowCorrelation' (ID 468196718). Data row does not have a matching index row in the index 'IX_Domain' (ID 2). Possible missing or invalid keys for the index row matching:

Msg 8955, Level 16, State 1, Line 5

Data row (1:737407:45) identified by (IPAddressSort = 1.182081310850000e+011) with index values 'Domain = '' and IPAddressSort = 1.182081310850000e+011'.

Msg 8951, Level 16, State 1, Line 5

Table error: table 'FlowCorrelation' (ID 468196718). Data row does not have a matching index row in the index 'IX_Domain' (ID 2). Possible missing or invalid keys for the index row matching:

Msg 8955, Level 16, State 1, Line 5

Data row (1:844587:56) identified by (IPAddressSort = 1.221211522110000e+011) with index values 'Domain = '' and IPAddressSort = 1.221211522110000e+011'.

Msg 8951, Level 16, State 1, Line 5

Table error: table 'FlowCorrelation' (ID 468196718). Data row does not have a matching index row in the index 'IX_Domain' (ID 2). Possible missing or invalid keys for the index row matching:

Msg 8955, Level 16, State 1, Line 5

Data row (1:944430:11) identified by (IPAddressSort = 1.221641550340000e+011) with index values 'Domain = '' and IPAddressSort = 1.221641550340000e+011'.

Msg 8951, Level 16, State 1, Line 5

Table error: table 'FlowCorrelation' (ID 468196718). Data row does not have a matching index row in the index 'IX_Domain' (ID 2). Possible missing or invalid keys for the index row matching:

Msg 8955, Level 16, State 1, Line 5

Data row (1:952057:11) identified by (IPAddressSort = 1.182081011210000e+011) with index values 'Domain = '' and IPAddressSort = 1.182081011210000e+011'.

Msg 8951, Level 16, State 1, Line 5

Table error: table 'FlowCorrelation' (ID 468196718). Data row does not have a matching index row in the index 'IX_Domain' (ID 2). Possible missing or invalid keys for the index row matching:

Msg 8955, Level 16, State 1, Line 5

Data row (1:1067723:0) identified by (IPAddressSort = 1.221670070610000e+011) with index values 'Domain = '' and IPAddressSort = 1.221670070610000e+011'.

Msg 8951, Level 16, State 1, Line 5

Table error: table 'FlowCorrelation' (ID 468196718). Data row does not have a matching index row in the index 'IX_Domain' (ID 2). Possible missing or invalid keys for the index row matching:

Msg 8955, Level 16, State 1, Line 5

Data row (1:1494309:26) identified by (IPAddressSort = 1.190730320740000e+011) with index values 'Domain = '' and IPAddressSort = 1.190730320740000e+011'.

Msg 8951, Level 16, State 1, Line 5

Table error: table 'FlowCorrelation' (ID 468196718). Data row does not have a matching index row in the index 'IX_Domain' (ID 2). Possible missing or invalid keys for the index row matching:

Msg 8955, Level 16, State 1, Line 5

Data row (1:1593737:33) identified by (IPAddressSort = 1.902300981990000e+011) with index values 'Domain = '' and IPAddressSort = 1.902300981990000e+011'.

Msg 8952, Level 16, State 1, Line 5

Table error: table 'FlowCorrelation' (ID 468196718). Index row in index 'IX_Domain' (ID 2) does not match any data row. Possible extra or invalid keys for:

Msg 8956, Level 16, State 1, Line 5

Index row (1:102529:13) with values (Domain = '122.airtelbroadband.in' and IPAddressSort = 1.221680090800000e+011) pointing to the data row identified by (IPAddressSort = 1.221680090800000e+011).

Msg 8952, Level 16, State 1, Line 5

Table error: table 'FlowCorrelation' (ID 468196718). Index row in index 'IX_Domain' (ID 2) does not match any data row. Possible extra or invalid keys for:

Msg 8956, Level 16, State 1, Line 5

Index row (1:125988:58) with values (Domain = '122.airtelbroadband.in' and IPAddressSort = 1.221631412360000e+011) pointing to the data row identified by (IPAddressSort = 1.221631412360000e+011).

Msg 8952, Level 16, State 1, Line 5

Table error: table 'FlowCorrelation' (ID 468196718). Index row in index 'IX_Domain' (ID 2) does not match any data row. Possible extra or invalid keys for:

Msg 8956, Level 16, State 1, Line 5

Index row (1:473489:4) with values (Domain = 'on.net' and IPAddressSort = 1.182082441390000e+011) pointing to the data row identified by (IPAddressSort = 1.182082441390000e+011).

Msg 8952, Level 16, State 1, Line 5

Table error: table 'FlowCorrelation' (ID 468196718). Index row in index 'IX_Domain' (ID 2) does not match any data row. Possible extra or invalid keys for:

Msg 8956, Level 16, State 1, Line 5

Index row (1:845249:90) with values (Domain = 'telecom.net.ar' and IPAddressSort = 1.902300981990000e+011) pointing to the data row identified by (IPAddressSort = 1.902300981990000e+011).

Msg 8952, Level 16, State 1, Line 5

Table error: table 'FlowCorrelation' (ID 468196718). Index row in index 'IX_Domain' (ID 2) does not match any data row. Possible extra or invalid keys for:

Msg 8956, Level 16, State 1, Line 5

Index row (1:871679:36) with values (Domain = '122.airtelbroadband.in' and IPAddressSort = 1.221632101640000e+011) pointing to the data row identified by (IPAddressSort = 1.221632101640000e+011).

Msg 8952, Level 16, State 1, Line 5

Table error: table 'FlowCorrelation' (ID 468196718). Index row in index 'IX_Domain' (ID 2) does not match any data row. Possible extra or invalid keys for:

Msg 8956, Level 16, State 1, Line 5

Index row (1:1547650:173) with values (Domain = '' and IPAddressSort = 1.890742271500000e+011) pointing to the data row identified by (IPAddressSort = 1.890742271500000e+011).

Msg 8952, Level 16, State 1, Line 5

Table error: table 'FlowCorrelation' (ID 468196718). Index row in index 'IX_Domain' (ID 2) does not match any data row. Possible extra or invalid keys for:

Msg 8956, Level 16, State 1, Line 5

Index row (1:1593402:58) with values (Domain = '' and IPAddressSort = 1.890700900710000e+011) pointing to the data row identified by (IPAddressSort = 1.890700900710000e+011).

Msg 8952, Level 16, State 1, Line 5

Table error: table 'FlowCorrelation' (ID 468196718). Index row in index 'IX_Domain' (ID 2) does not match any data row. Possible extra or invalid keys for:

Msg 8956, Level 16, State 1, Line 5

Index row (1:1605660:117) with values (Domain = '' and IPAddressSort = 2.131141372190000e+011) pointing to the data row identified by (IPAddressSort = 2.131141372190000e+011).

Msg 8979, Level 16, State 1, Line 5

Table error: Object ID 468196718, index ID 5, partition ID 72057594052476928, alloc unit ID 72057594058702848 (type In-row data). Page (1:451970) is missing references from parent (unknown) and previous (page (1:314796)) nodes. Possible bad root entry in system catalog.

Msg 8935, Level 16, State 1, Line 5

Table error: Object ID 468196718, index ID 5, partition ID 72057594052476928, alloc unit ID 72057594058702848 (type In-row data). The previous link (1:1175411) on page (1:1175410) does not match the previous page (1:450996) that the parent (1:425229), slot 207 expects for this page.

Msg 8935, Level 16, State 1, Line 5

Table error: Object ID 468196718, index ID 5, partition ID 72057594052476928, alloc unit ID 72057594058702848 (type In-row data). The previous link (1:1008441) on page (1:1175411) does not match the previous page (1:1175412) that the parent (1:425229), slot 209 expects for this page.

Msg 8978, Level 16, State 1, Line 5

Table error: Object ID 468196718, index ID 5, partition ID 72057594052476928, alloc unit ID 72057594058702848 (type In-row data). Page (1:1175411) is missing a reference from previous page (1:1008441). Possible chain linkage problem.

Msg 8981, Level 16, State 1, Line 5

Table error: Object ID 468196718, index ID 5, partition ID 72057594052476928, alloc unit ID 72057594058702848 (type In-row data). The next pointer of (1:1175412) refers to page (1:1179169). Neither (1:1179169) nor its parent were encountered. Possible bad chain linkage.

Msg 8980, Level 16, State 1, Line 5

Table error: Object ID 468196718, index ID 5, partition ID 72057594052476928, alloc unit ID 72057594058702848 (type In-row data). Index node page (1:1026154), slot 0 refers to child page (1:1179170) and previous child (0:1), but they were not encountered.

Msg 8980, Level 16, State 1, Line 5

Table error: Object ID 468196718, index ID 5, partition ID 72057594052476928, alloc unit ID 72057594058702848 (type In-row data). Index node page (1:1188491), slot 0 refers to child page (1:1179420) and previous child (0:1), but they were not encountered.

Msg 8936, Level 16, State 1, Line 5

Table error: Object ID 468196718, index ID 5, partition ID 72057594052476928, alloc unit ID 72057594058702848 (type In-row data). B-tree chain linkage mismatch. (1:1008441)->next = (1:1179421), but (1:1179421)->Prev = (1:1179420).

Msg 8978, Level 16, State 1, Line 5

Table error: Object ID 468196718, index ID 6, partition ID 72057594052542464, alloc unit ID 72057594058768384 (type In-row data). Page (1:106123) is missing a reference from previous page (1:1592844). Possible chain linkage problem.

Msg 8978, Level 16, State 1, Line 5

Table error: Object ID 468196718, index ID 6, partition ID 72057594052542464, alloc unit ID 72057594058768384 (type In-row data). Page (1:1447704) is missing a reference from previous page (1:1584783). Possible chain linkage problem.

Msg 8980, Level 16, State 1, Line 5

Table error: Object ID 468196718, index ID 6, partition ID 72057594052542464, alloc unit ID 72057594058768384 (type In-row data). Index node page (1:1536858), slot 236 refers to child page (1:1575268) and previous child (1:1584778), but they were not encountered.

Msg 8976, Level 16, State 1, Line 5

Table error: Object ID 468196718, index ID 6, partition ID 72057594052542464, alloc unit ID 72057594058768384 (type In-row data). Page (1:1584778) was not seen in the scan although its parent (1:1536858) and previous (1:1446065) refer to it. Check any previous errors.

Msg 8976, Level 16, State 1, Line 5

Table error: Object ID 468196718, index ID 6, partition ID 72057594052542464, alloc unit ID 72057594058768384 (type In-row data). Page (1:1584783) was not seen in the scan although its parent (1:1542277) and previous (1:1447517) refer to it. Check any previous errors.

Msg 8979, Level 16, State 1, Line 5

Table error: Object ID 468196718, index ID 6, partition ID 72057594052542464, alloc unit ID 72057594058768384 (type In-row data). Page (1:1585142) is missing references from parent (unknown) and previous (page (1:885586)) nodes. Possible bad root entry in system catalog.

Msg 8979, Level 16, State 1, Line 5

Table error: Object ID 468196718, index ID 6, partition ID 72057594052542464, alloc unit ID 72057594058768384 (type In-row data). Page (1:1585187) is missing references from parent (unknown) and previous (page (1:1585142)) nodes. Possible bad root entry in system catalog.

Msg 8979, Level 16, State 1, Line 5

Table error: Object ID 468196718, index ID 6, partition ID 72057594052542464, alloc unit ID 72057594058768384 (type In-row data). Page (1:1585190) is missing references from parent (unknown) and previous (page (1:1585142)) nodes. Possible bad root entry in system catalog.

Msg 8933, Level 16, State 1, Line 5

Table error: Object ID 468196718, index ID 6, partition ID 72057594052542464, alloc unit ID 72057594058768384 (type In-row data). The low key value on page (1:1585215) (level 1) is not == the key value in the parent (1:223368) slot 1.

Msg 8979, Level 16, State 1, Line 5

Table error: Object ID 468196718, index ID 6, partition ID 72057594052542464, alloc unit ID 72057594058768384 (type In-row data). Page (1:1587201) is missing references from parent (unknown) and previous (page (1:885586)) nodes. Possible bad root entry in system catalog.

Msg 8979, Level 16, State 1, Line 5

Table error: Object ID 468196718, index ID 6, partition ID 72057594052542464, alloc unit ID 72057594058768384 (type In-row data). Page (1:1592220) is missing references from parent (unknown) and previous (page (1:1587201)) nodes. Possible bad root entry in system catalog.

Msg 8979, Level 16, State 1, Line 5

Table error: Object ID 468196718, index ID 6, partition ID 72057594052542464, alloc unit ID 72057594058768384 (type In-row data). Page (1:1592333) is missing references from parent (unknown) and previous (page (1:885586)) nodes. Possible bad root entry in system catalog.

Msg 8979, Level 16, State 1, Line 5

Table error: Object ID 468196718, index ID 6, partition ID 72057594052542464, alloc unit ID 72057594058768384 (type In-row data). Page (1:1592334) is missing references from parent (unknown) and previous (page (1:1587201)) nodes. Possible bad root entry in system catalog.

Msg 8935, Level 16, State 1, Line 5

Table error: Object ID 468196718, index ID 6, partition ID 72057594052542464, alloc unit ID 72057594058768384 (type In-row data). The previous link (1:885586) on page (1:1592809) does not match the previous page (1:1584781) that the parent (1:1542277), slot 268 expects for this page.

Msg 8978, Level 16, State 1, Line 5

Table error: Object ID 468196718, index ID 6, partition ID 72057594052542464, alloc unit ID 72057594058768384 (type In-row data). Page (1:1592809) is missing a reference from previous page (1:885586). Possible chain linkage problem.

Msg 8936, Level 16, State 1, Line 5

Table error: Object ID 468196718, index ID 6, partition ID 72057594052542464, alloc unit ID 72057594058768384 (type In-row data). B-tree chain linkage mismatch. (1:1592850)->next = (1:1592813), but (1:1592813)->Prev = (1:885586).

Msg 8935, Level 16, State 1, Line 5

Table error: Object ID 468196718, index ID 6, partition ID 72057594052542464, alloc unit ID 72057594058768384 (type In-row data). The previous link (1:885586) on page (1:1592844) does not match the previous page (1:1575268) that the parent (1:1536858), slot 237 expects for this page.

Msg 8978, Level 16, State 1, Line 5

Table error: Object ID 468196718, index ID 6, partition ID 72057594052542464, alloc unit ID 72057594058768384 (type In-row data). Page (1:1592844) is missing a reference from previous page (1:885586). Possible chain linkage problem.

Msg 8935, Level 16, State 1, Line 5

Table error: Object ID 468196718, index ID 6, partition ID 72057594052542464, alloc unit ID 72057594058768384 (type In-row data). The previous link (1:885586) on page (1:1592850) does not match the previous page (1:1592851) that the parent (1:1542277), slot 270 expects for this page.

Msg 8978, Level 16, State 1, Line 5

Table error: Object ID 468196718, index ID 6, partition ID 72057594052542464, alloc unit ID 72057594058768384 (type In-row data). Page (1:1592850) is missing a reference from previous page (1:885586). Possible chain linkage problem.

Msg 8937, Level 16, State 1, Line 5

Table error: Object ID 468196718, index ID 6, partition ID 72057594052542464, alloc unit ID 72057594058768384 (type In-row data). B-tree page (1:1592851) has two parent nodes (1:1585215), slot 1 and (1:1542277), slot 269.

Msg 8936, Level 16, State 1, Line 5

Table error: Object ID 468196718, index ID 6, partition ID 72057594052542464, alloc unit ID 72057594058768384 (type In-row data). B-tree chain linkage mismatch. (1:885586)->next = (1:1592853), but (1:1592853)->Prev = (1:1592851).

Msg 8937, Level 16, State 1, Line 5

Table error: Object ID 468196718, index ID 6, partition ID 72057594052542464, alloc unit ID 72057594058768384 (type In-row data). B-tree page (1:1592853) has two parent nodes (1:937194), slot 0 and (1:1585215), slot 2.

There are 14940175 rows in 319970 pages for object "FlowCorrelation".

CHECKDB found 0 allocation errors and 60 consistency errors in table 'FlowCorrelation' (object ID 468196718).

DBCC results for 'APM_ComponentStatus_Daily'.

There are 2301 rows in 36 pages for object "APM_ComponentStatus_Daily".

DBCC results for 'IPAddressGroups'.

There are 5 rows in 1 pages for object "IPAddressGroups".

DBCC results for 'TransportProtocols'.

There are 141 rows in 1 pages for object "TransportProtocols".

DBCC results for 'APM_ComponentStatus_Detail'.

Msg 8951, Level 16, State 1, Line 5

Table error: table 'APM_ComponentStatus_Detail' (ID 535672956). Data row does not have a matching index row in the index 'IX_APM_ComponentStatus_Detail_ComponentID' (ID 2). Possible missing or invalid keys for the index row matching:

Msg 8955, Level 16, State 1, Line 5

Data row (1:4282:93) identified by (ID = 1853666 and Archive = 0) with index values 'ComponentID = 60 and TimeStamp = '2009-09-16 01:49:52.703' and ID = 1853666 and Archive = 0'.

Msg 8951, Level 16, State 1, Line 5

Table error: table 'APM_ComponentStatus_Detail' (ID 535672956). Data row does not have a matching index row in the index 'IX_APM_ComponentStatus_Detail_ComponentID' (ID 2). Possible missing or invalid keys for the index row matching:

Msg 8955, Level 16, State 1, Line 5

Data row (1:4282:94) identified by (ID = 1853667 and Archive = 0) with index values 'ComponentID = 66 and TimeStamp = '2009-09-16 01:49:53.093' and ID = 1853667 and Archive = 0'.

Msg 8951, Level 16, State 1, Line 5

Table error: table 'APM_ComponentStatus_Detail' (ID 535672956). Data row does not have a matching index row in the index 'IX_APM_ComponentStatus_Detail_ComponentID' (ID 2). Possible missing or invalid keys for the index row matching:

Msg 8955, Level 16, State 1, Line 5

Data row (1:4282:95) identified by (ID = 1853668 and Archive = 0) with index values 'ComponentID = 67 and TimeStamp = '2009-09-16 01:49:53.250' and ID = 1853668 and Archive = 0'.

Msg 8951, Level 16, State 1, Line 5

Table error: table 'APM_ComponentStatus_Detail' (ID 535672956). Data row does not have a matching index row in the index 'IX_APM_ComponentStatus_Detail_ComponentID' (ID 2). Possible missing or invalid keys for the index row matching:

Msg 8955, Level 16, State 1, Line 5

Data row (1:4282:96) identified by (ID = 1853669 and Archive = 0) with index values 'ComponentID = 68 and TimeStamp = '2009-09-16 01:49:53.343' and ID = 1853669 and Archive = 0'.

Msg 8951, Level 16, State 1, Line 5

Table error: table 'APM_ComponentStatus_Detail' (ID 535672956). Data row does not have a matching index row in the index 'IX_APM_ComponentStatus_Detail_ComponentID' (ID 2). Possible missing or invalid keys for the index row matching:

Msg 8955, Level 16, State 1, Line 5

Data row (1:4282:97) identified by (ID = 1853670 and Archive = 0) with index values 'ComponentID = 69 and TimeStamp = '2009-09-16 01:49:53.377' and ID = 1853670 and Archive = 0'.

Msg 8951, Level 16, State 1, Line 5

Table error: table 'APM_ComponentStatus_Detail' (ID 535672956). Data row does not have a matching index row in the index 'IX_APM_ComponentStatus_Detail_ComponentID' (ID 2). Possible missing or invalid keys for the index row matching:

Msg 8955, Level 16, State 1, Line 5

Data row (1:4282:98) identified by (ID = 1853671 and Archive = 0) with index values 'ComponentID = 70 and TimeStamp = '2009-09-16 01:49:53.470' and ID = 1853671 and Archive = 0'.

Msg 8951, Level 16, State 1, Line 5

Table error: table 'APM_ComponentStatus_Detail' (ID 535672956). Data row does not have a matching index row in the index 'IX_APM_ComponentStatus_Detail_ComponentID' (ID 2). Possible missing or invalid keys for the index row matching:

Msg 8955, Level 16, State 1, Line 5

Data row (1:4282:99) identified by (ID = 1853672 and Archive = 0) with index values 'ComponentID = 71 and TimeStamp = '2009-09-16 01:49:53.563' and ID = 1853672 and Archive = 0'.

Msg 8951, Level 16, State 1, Line 5

Table error: table 'APM_ComponentStatus_Detail' (ID 535672956). Data row does not have a matching index row in the index 'IX_APM_ComponentStatus_Detail_ComponentID' (ID 2). Possible missing or invalid keys for the index row matching:

Msg 8955, Level 16, State 1, Line 5

Data row (1:4282:100) identified by (ID = 1853673 and Archive = 0) with index values 'ComponentID = 72 and TimeStamp = '2009-09-16 01:49:53.593' and ID = 1853673 and Archive = 0'.

Msg 8951, Level 16, State 1, Line 5

Table error: table 'APM_ComponentStatus_Detail' (ID 535672956). Data row does not have a matching index row in the index 'IX_APM_ComponentStatus_Detail_ComponentID' (ID 2). Possible missing or invalid keys for the index row matching:

Msg 8955, Level 16, State 1, Line 5

Data row (1:4282:101) identified by (ID = 1853674 and Archive = 0) with index values 'ComponentID = 73 and TimeStamp = '2009-09-16 01:49:53.627' and ID = 1853674 and Archive = 0'.

Msg 8951, Level 16, State 1, Line 5

Table error: table 'APM_ComponentStatus_Detail' (ID 535672956). Data row does not have a matching index row in the index 'IX_APM_ComponentStatus_Detail_ComponentID' (ID 2). Possible missing or invalid keys for the index row matching:

Msg 8955, Level 16, State 1, Line 5

Data row (1:4282:102) identified by (ID = 1853675 and Archive = 0) with index values 'ComponentID = 74 and TimeStamp = '2009-09-16 01:49:53.657' and ID = 1853675 and Archive = 0'.

Msg 8951, Level 16, State 1, Line 5

Table error: table 'APM_ComponentStatus_Detail' (ID 535672956). Data row does not have a matching index row in the index 'IX_APM_ComponentStatus_Detail_ComponentID' (ID 2). Possible missing or invalid keys for the index row matching:

Msg 8955, Level 16, State 1, Line 5

Data row (1:4282:103) identified by (ID = 1853676 and Archive = 0) with index values 'ComponentID = 76 and TimeStamp = '2009-09-16 01:49:53.720' and ID = 1853676 and Archive = 0'.

Msg 8951, Level 16, State 1, Line 5

Table error: table 'APM_ComponentStatus_Detail' (ID 535672956). Data row does not have a matching index row in the index 'IX_APM_ComponentStatus_Detail_ComponentID' (ID 2). Possible missing or invalid keys for the index row matching:

Msg 8955, Level 16, State 1, Line 5

Data row (1:4282:104) identified by (ID = 1853677 and Archive = 0) with index values 'ComponentID = 88 and TimeStamp = '2009-09-16 01:49:54.093' and ID = 1853677 and Archive = 0'.

Msg 8951, Level 16, State 1, Line 5

Table error: table 'APM_ComponentStatus_Detail' (ID 535672956). Data row does not have a matching index row in the index 'IX_APM_ComponentStatus_Detail_ComponentID' (ID 2). Possible missing or invalid keys for the index row matching:

Msg 8955, Level 16, State 1, Line 5

Data row (1:4282:105) identified by (ID = 1853678 and Archive = 0) with index values 'ComponentID = 79 and TimeStamp = '2009-09-16 01:49:53.813' and ID = 1853678 and Archive = 0'.

Msg 8951, Level 16, State 1, Line 5

Table error: table 'APM_ComponentStatus_Detail' (ID 535672956). Data row does not have a matching index row in the index 'IX_APM_ComponentStatus_Detail_ComponentID' (ID 2). Possible missing or invalid keys for the index row matching:

Msg 8955, Level 16, State 1, Line 5

Data row (1:4282:106) identified by (ID = 1853679 and Archive = 0) with index values 'ComponentID = 75 and TimeStamp = '2009-09-16 01:49:53.687' and ID = 1853679 and Archive = 0'.

Msg 8951, Level 16, State 1, Line 5

Table error: table 'APM_ComponentStatus_Detail' (ID 535672956). Data row does not have a matching index row in the index 'IX_APM_ComponentStatus_Detail_ComponentID' (ID 2). Possible missing or invalid keys for the index row matching:

Msg 8955, Level 16, State 1, Line 5

Data row (1:4282:107) identified by (ID = 1853680 and Archive = 0) with index values 'ComponentID = 81 and TimeStamp = '2009-09-16 01:49:53.937' and ID = 1853680 and Archive = 0'.

Msg 8951, Level 16, State 1, Line 5

Table error: table 'APM_ComponentStatus_Detail' (ID 535672956). Data row does not have a matching index row in the index 'IX_APM_ComponentStatus_Detail_ComponentID' (ID 2). Possible missing or invalid keys for the index row matching:

Msg 8955, Level 16, State 1, Line 5

Data row (1:4282:108) identified by (ID = 1853681 and Archive = 0) with index values 'ComponentID = 80 and TimeStamp = '2009-09-16 01:49:53.843' and ID = 1853681 and Archive = 0'.

Msg 8951, Level 16, State 1, Line 5

Table error: table 'APM_ComponentStatus_Detail' (ID 535672956). Data row does not have a matching index row in the index 'IX_APM_ComponentStatus_Detail_ComponentID' (ID 2). Possible missing or invalid keys for the index row matching:

Msg 8955, Level 16, State 1, Line 5

Data row (1:4282:109) identified by (ID = 1853682 and Archive = 0) with index values 'ComponentID = 61 and TimeStamp = '2009-09-16 01:49:52.797' and ID = 1853682 and Archive = 0'.

Msg 8951, Level 16, State 1, Line 5

Table error: table 'APM_ComponentStatus_Detail' (ID 535672956). Data row does not have a matching index row in the index 'IX_APM_ComponentStatus_Detail_ComponentID' (ID 2). Possible missing or invalid keys for the index row matching:

Msg 8955, Level 16, State 1, Line 5

Data row (1:4282:110) identified by (ID = 1853683 and Archive = 0) with index values 'ComponentID = 62 and TimeStamp = '2009-09-16 01:49:52.827' and ID = 1853683 and Archive = 0'.

Msg 8951, Level 16, State 1, Line 5

Table error: table 'APM_ComponentStatus_Detail' (ID 535672956). Data row does not have a matching index row in the index 'IX_APM_ComponentStatus_Detail_ComponentID' (ID 2). Possible missing or invalid keys for the index row matching:

Msg 8955, Level 16, State 1, Line 5

Data row (1:4282:111) identified by (ID = 1853684 and Archive = 0) with index values 'ComponentID = 65 and TimeStamp = '2009-09-16 01:49:52.877' and ID = 1853684 and Archive = 0'.

Msg 8951, Level 16, State 1, Line 5

Table error: table 'APM_ComponentStatus_Detail' (ID 535672956). Data row does not have a matching index row in the index 'IX_APM_ComponentStatus_Detail_ComponentID' (ID 2). Possible missing or invalid keys for the index row matching:

Msg 8955, Level 16, State 1, Line 5

Data row (1:4282:112) identified by (ID = 1853685 and Archive = 0) with index values 'ComponentID = 82 and TimeStamp = '2009-09-16 01:49:53.970' and ID = 1853685 and Archive = 0'.

Msg 8951, Level 16, State 1, Line 5

Table error: table 'APM_ComponentStatus_Detail' (ID 535672956). Data row does not have a matching index row in the index 'IX_APM_ComponentStatus_Detail_ComponentID' (ID 2). Possible missing or invalid keys for the index row matching:

Msg 8955, Level 16, State 1, Line 5

Data row (1:4282:113) identified by (ID = 1853686 and Archive = 0) with index values 'ComponentID = 86 and TimeStamp = '2009-09-16 01:49:54.000' and ID = 1853686 and Archive = 0'.

There are 92805 rows in 670 pages for object "APM_ComponentStatus_Detail".

CHECKDB found 0 allocation errors and 21 consistency errors in table 'APM_ComponentStatus_Detail' (object ID 535672956).

DBCC results for 'CiscoBuffers_Detail'.

There are 1548 rows in 37 pages for object "CiscoBuffers_Detail".

DBCC results for 'APM_ComponentStatus_Hourly'.

There are 21820 rows in 232 pages for object "APM_ComponentStatus_Hourly".

DBCC results for 'ConstituentPorts'.

There are 19479 rows in 41 pages for object "ConstituentPorts".

DBCC results for 'CustomPollerScratchStatistics'.

There are 0 rows in 0 pages for object "CustomPollerScratchStatistics".

DBCC results for 'AlertLog'.

There are 278997 rows in 6127 pages for object "AlertLog".

DBCC results for 'FlowEngines'.

There are 1 rows in 1 pages for object "FlowEngines".

DBCC results for 'APM_ComponentTemplate'.

There are 220 rows in 3 pages for object "APM_ComponentTemplate".

DBCC results for 'Websites'.

There are 1 rows in 1 pages for object "Websites".

DBCC results for 'APM_ComponentTemplateSetting'.

There are 997 rows in 9 pages for object "APM_ComponentTemplateSetting".

DBCC results for 'WebUserSettings'.

There are 20 rows in 1 pages for object "WebUserSettings".

DBCC results for 'AlertStatus'.

There are 15 rows in 2 pages for object "AlertStatus".

DBCC results for 'CustomPollerStatus'.

There are 0 rows in 0 pages for object "CustomPollerStatus".

DBCC results for 'MultiPortApps'.

There are 7 rows in 1 pages for object "MultiPortApps".

DBCC results for 'APM_Config'.

There are 4 rows in 1 pages for object "APM_Config".

DBCC results for 'CiscoBuffers_Hourly'.

There are 5655 rows in 57 pages for object "CiscoBuffers_Hourly".

DBCC results for 'APM_Credentials'.

There are 4 rows in 1 pages for object "APM_Credentials".

DBCC results for 'Engines'.

There are 1 rows in 1 pages for object "Engines".

DBCC results for 'APM_CurrentApplicationStatus'.

There are 14 rows in 1 pages for object "APM_CurrentApplicationStatus".

DBCC results for 'NetFlowAddressToResolve'.

Msg 8978, Level 16, State 1, Line 5

Table error: Object ID 788197858, index ID 1, partition ID 72057594052673536, alloc unit ID 72057594058899456 (type In-row data). Page (1:78531) is missing a reference from previous page (1:1545410). Possible chain linkage problem.

Msg 8978, Level 16, State 1, Line 5

Table error: Object ID 788197858, index ID 1, partition ID 72057594052673536, alloc unit ID 72057594058899456 (type In-row data). Page (1:697934) is missing a reference from previous page (1:1545408). Possible chain linkage problem.

Msg 8978, Level 16, State 1, Line 5

Table error: Object ID 788197858, index ID 1, partition ID 72057594052673536, alloc unit ID 72057594058899456 (type In-row data). Page (1:746268) is missing a reference from previous page (1:1545409). Possible chain linkage problem.

Msg 8976, Level 16, State 1, Line 5

Table error: Object ID 788197858, index ID 1, partition ID 72057594052673536, alloc unit ID 72057594058899456 (type In-row data). Page (1:1545408) was not seen in the scan although its parent (1:1017094) and previous (1:427958) refer to it. Check any previous errors.

Msg 8976, Level 16, State 1, Line 5

Table error: Object ID 788197858, index ID 1, partition ID 72057594052673536, alloc unit ID 72057594058899456 (type In-row data). Page (1:1545409) was not seen in the scan although its parent (1:1542208) and previous (1:57802) refer to it. Check any previous errors.

Msg 8976, Level 16, State 1, Line 5

Table error: Object ID 788197858, index ID 1, partition ID 72057594052673536, alloc unit ID 72057594058899456 (type In-row data). Page (1:1545410) was not seen in the scan although its parent (1:322257) and previous (1:631773) refer to it. Check any previous errors.