Recovery :: Maintain Transnational Consistency Of Data Across Both Servers

Sep 15, 2015

I have two production servers in the same data center. I need to ensure that database remains available if a catastrophic server failure or a disk failure occurs. I need to maintain transactional consistency of the data across both servers. I need to achieve these goals without manual intervention. I was suggested to use this optionTwo servers configured on the same subnet. SQL Server Availability Group configured in Synchronous-Commit Availability Mode<<<<But I think the correct answer should be Two servers configured in Windows Failover Cluster in the same data center SQL Server configured as a clustered instance<<<<

View 2 Replies


ADVERTISEMENT

To Maintain Two Different Connections For Different Servers In ASP.Net Application(sql Server And Oracle)

Oct 10, 2007

I am working in ASP.NET 2.0 and using sql server 2000 as backend . In my application i need to insert/update to oracle database table lying on different server. Please let me know how can i maintain two different connecttions to different databases lying on different servers..... 

View 1 Replies View Related

To Maintain Two Different Connections For Different Servers In ASP.Net Application(sql Server And Oracle)

Oct 10, 2007

I am working in ASP.NET 2.0 and using sql server 2000 as backend . In my
application i need to insert/update to oracle database table lying on
different server. Please let me know how can i maintain two different
connecttions to different databases lying on different servers.....

View 1 Replies View Related

Maintain A Sql Data Base

Aug 15, 2005

Sebastian Garibaldi writes "Hi I'm Sebastian from Argentina, and i have a problem with a SQL data base. I receive error from data base of broken index and consistency errors. I set the fill factor with the information from the books online, i put 70 in tables that have a lot of INSERT/UPDATE/DELETE but it works for two o tree days.

I now that i must make some maintain in the database but which tools i shuld use?

here i paste an error from dbcc checktable:


Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 981108969. The text, ntext, or image node at page (1:949979), slot 52, text ID 57535781339136 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 981108969. The text, ntext, or image node at page (1:949979), slot 53, text ID 57535782191104 is not referenced.
DBCC results for 'FCRMVI'.
There are 108460 rows in 17430 pages for object 'FCRMVI'.
CHECKTABLE found 0 allocation errors and 2 consistency errors in table 'FCRMVI' (object ID 981108969).
repair_allow_data_loss is the minimum repair level for the errors found by DBCC CHECKTABLE (ArleiProd.dbo.FCRMVI ).



thanks, and sorry my english."

View 1 Replies View Related

Restore Data But Maintain Replication Settings?

Jun 17, 2008

We are setting up the clients' database with transactional replication that allows the subscriber to send updates by pull subscriptions.

The plan is to create a second database so the users can keep working on the original database while we get the replication set up and working. Once we feel confident that the replication is working on the second database, the plan was to backup the old one, then detach it, and then restore the new database with the latest data from the old one. My question is whether this would preserve all the replication configurations that we set up? Since the replication adds a column to each table what would happen to that column? Or what is an alternative, which would allow us to set up the replication without disturbing the user's work, and then implement the replication with the latest data?

I am also wondering how to set the synchronization to happen once daily? I do not see where I can set that. I only see options for continuous vs on demand. Does on demand mean I can somehow schedule with an external program to run once a day?

Thanks for your patience, and I hope my questions make sense.

View 11 Replies View Related

How To Get Rid Of Consistency Errors Without Data

Jul 6, 2005

Vimal Kanth writes "I am using SQL Server 2000 and one of my databases has loads of consistency errors. When i try to query a particular record from a table it displays an error message similar to this


Could not find the index entry for RID '168927001232500300' in index page (1:95510), index ID 0, database 'Tristar'.


Then, i executed the DBCC CHECKDB command after going through some documentation. The results of which were something like this


Table error: Database 'Tristar', index 'DMS_VOUCHER.index_1739153241' (ID 1739153241) (index ID 2). Extra or invalid key for the keys:

Index row (1:11229:144) with values (ROWGUID = 22814645-5B2B-4B4E-A1D8-9B49DF7C8CEF`¢0; and DEALER_ID = 10121 and BRANCH_ID = 1.242260474E-307 and VOUCHER_ID = 9507) points to the data row identified by ().


Then, i executed the DBCC CHECKDB REPAIR_ALLOW_DATA_LOSS command. I lost around 3000 records when i excuted this

I dont want any data loss as this is very critical.Can you please help me overcome this problem? Thanks in advance.

Regards
Vimal Kanth"

View 20 Replies View Related

Data Consistency Errors

Apr 27, 2006

Can anyone please tell me why I recieved these errors when running dbcc check db. Thank god it was a user created "test" table in a production database and I was able to just drop the table and rerun dbcc with no errors, but this is the second time this has happened in the last month(I just started this job the week of the first error)- and we ended up having to restore to the last good backup.

Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 1543676547. The text, ntext, or image node at page (1:652192), slot 3, text ID 225434796032 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 1543676547. The text, ntext, or image node at page (1:652192), slot 4, text ID 225434861568 is not referenced.
Server: Msg 8928, Level 16, State 1, Line 1
Object ID 1543676547, index ID 255: Page (1:652193) could not be processed. See other errors for details.
Server: Msg 8939, Level 16, State 1, Line 1
Table error: Object ID 1543676547, index ID 255, page (1:652193). Test (IS_ON (BUF_IOERR, bp->bstat) &&bp->berrcode) failed. Values are 2057 and -1.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 1543676547. The text, ntext, or image node at page (1:652194), slot 0, text ID 225434730496 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 1543676547. The text, ntext, or image node at page (1:652194), slot 1, text ID 225434927104 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 1543676547. The text, ntext, or image node at page (1:652194), slot 2, text ID 225434992640 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 1543676547. The text, ntext, or image node at page (1:652194), slot 3, text ID 225435058176 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 1543676547. The text, ntext, or image node at page (1:652194), slot 4, text ID 225435123712 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 1543676547. The text, ntext, or image node at page (1:652194), slot 5, text ID 225435189248 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 1543676547. The text, ntext, or image node at page (1:652194), slot 6, text ID 225435254784 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 1543676547. The text, ntext, or image node at page (1:652194), slot 7, text ID 225435320320 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 1543676547. The text, ntext, or image node at page (1:652195), slot 0, text ID 225435385856 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 1543676547. The text, ntext, or image node at page (1:652195), slot 1, text ID 225435451392 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 1543676547. The text, ntext, or image node at page (1:652195), slot 2, text ID 225435516928 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 1543676547. The text, ntext, or image node at page (1:652195), slot 3, text ID 225435582464 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 1543676547. The text, ntext, or image node at page (1:652195), slot 4, text ID 225435648000 is not referenced.
DBCC results for 'BILL_PRT_DETAIL'.
There are 909154 rows in 101409 pages for object 'BILL_PRT_DETAIL'.
DBCC results for 'BILLG_ERR_MSGS'.
There are 971 rows in 52 pages for object 'BILLG_ERR_MSGS'.
DBCC results for 'WORK_COMPCY_LEVEL'.
There are 0 rows in 0 pages for object 'WORK_COMPCY_LEVEL'.
DBCC results for 'BILL_PRT_HEADER'.
There are 196396 rows in 24550 pages for object 'BILL_PRT_HEADER'.
DBCC results for 'WORK_COMPCY_TYPE'.
There are 0 rows in 0 pages for object 'WORK_COMPCY_TYPE'.
DBCC results for 'BILL_PRT_MSGS'.
There are 0 rows in 0 pages for object 'BILL_PRT_MSGS'.
DBCC results for 'MTR_TMP_DTA_SEL'.
There are 0 rows in 0 pages for object 'MTR_TMP_DTA_SEL'.
DBCC results for 'WORK_IN_PROGRESS'.
There are 1 rows in 1 pages for object 'WORK_IN_PROGRESS'.
DBCC results for 'BILL_PYMT'.
There are 750053 rows in 19951 pages for object 'BILL_PYMT'.
DBCC results for 'NOTES'.
There are 26812 rows in 457 pages for object 'NOTES'.
DBCC results for 'WORK_ORDER_MASTER'.
There are 0 rows in 0 pages for object 'WORK_ORDER_MASTER'.
DBCC results for 'BUD_BILLG_AMT'.
There are 0 rows in 0 pages for object 'BUD_BILLG_AMT'.
DBCC results for 'NOTES_RELSHP'.
There are 22428 rows in 252 pages for object 'NOTES_RELSHP'.
DBCC results for 'WO_ACT_STAT'.
There are 0 rows in 0 pages for object 'WO_ACT_STAT'.
DBCC results for 'BUD_BILLG_CNSM_HST'.
There are 0 rows in 0 pages for object 'BUD_BILLG_CNSM_HST'.
DBCC results for 'NXT_NBR'.
There are 7 rows in 1 pages for object 'NXT_NBR'.
DBCC results for 'WO_ADDTNL_INFO'.
There are 0 rows in 0 pages for object 'WO_ADDTNL_INFO'.
DBCC results for 'BUD_BILLG_HST'.
There are 0 rows in 0 pages for object 'BUD_BILLG_HST'.
DBCC results for 'PARENT_HST'.
There are 0 rows in 0 pages for object 'PARENT_HST'.
DBCC results for 'WO_APPVL_ROUTING'.
There are 0 rows in 0 pages for object 'WO_APPVL_ROUTING'.
DBCC results for 'BUD_BILLG_WTHR_HST'.
There are 0 rows in 0 pages for object 'BUD_BILLG_WTHR_HST'.
DBCC results for 'PHY_ADDR'.
There are 70776 rows in 7905 pages for object 'PHY_ADDR'.
DBCC results for 'WO_BEHAVIOR_RULE'.
There are 0 rows in 0 pages for object 'WO_BEHAVIOR_RULE'.
DBCC results for 'BUD_BILLG_WTHR_SEV'.
There are 0 rows in 0 pages for object 'BUD_BILLG_WTHR_SEV'.
DBCC results for 'POSTAL_TOWN_CD'.
There are 29539 rows in 569 pages for object 'POSTAL_TOWN_CD'.
DBCC results for 'WO_COMPONENTS'.
There are 0 rows in 0 pages for object 'WO_COMPONENTS'.
DBCC results for 'BUS_UNT'.
There are 1310 rows in 25 pages for object 'BUS_UNT'.
DBCC results for 'cash match'.
There are 738871 rows in 6720 pages for object 'cash match'.
DBCC results for 'POSTED_HISTORY'.
There are 1230436 rows in 26768 pages for object 'POSTED_HISTORY'.
DBCC results for 'WO_CONSTANTS'.
There are 0 rows in 0 pages for object 'WO_CONSTANTS'.
DBCC results for 'BUS_UNT_MSTR'.
There are 0 rows in 0 pages for object 'BUS_UNT_MSTR'.
DBCC results for 'Cashmatch7_30'.
There are 727509 rows in 6619 pages for object 'Cashmatch7_30'.
DBCC results for 'PROFILE_CAT'.
There are 0 rows in 0 pages for object 'PROFILE_CAT'.
DBCC results for 'WO_EDIT_RULE'.
There are 0 rows in 0 pages for object 'WO_EDIT_RULE'.
DBCC results for 'CNSMPTN_SVC_CONTN'.
There are 36776 rows in 928 pages for object 'CNSMPTN_SVC_CONTN'.
DBCC results for 'Trace_cash_match'.
There are 815011 rows in 7412 pages for object 'Trace_cash_match'.
DBCC results for 'PROOF_BILL_PRT_DTL'.
There are 0 rows in 0 pages for object 'PROOF_BILL_PRT_DTL'.
DBCC results for 'WO_MASTER_FILE'.
There are 0 rows in 0 pages for object 'WO_MASTER_FILE'.
DBCC results for 'cash match 8-24'.
There are 815011 rows in 7414 pages for object 'cash match 8-24'.
CHECKDB found 0 allocation errors and 17 consistency errors in table 'cash match 8-24' (object ID 1543676547).
DBCC results for 'PROOF_BILL_PRT_HDR'.
There are 0 rows in 0 pages for object 'PROOF_BILL_PRT_HDR'.
DBCC results for 'CNVRGT_BILLG_DTL'.
There are 0 rows in 0 pages for object 'CNVRGT_BILLG_DTL'.
DBCC results for 'WO_RTG_APPVL_MSTR'.
There are 0 rows in 0 pages for object 'WO_RTG_APPVL_MSTR'.
DBCC results for 'PYMT_TERMS'.
There are 2 rows in 1 pages for object 'PYMT_TERMS'.
DBCC results for 'CNVRGT_BILLG_HDR'.
There are 0 rows in 0 pages for object 'CNVRGT_BILLG_HDR'.
DBCC results for 'WO_STAT'.
There are 0 rows in 0 pages for object 'WO_STAT'.
DBCC results for 'Cash Matching Process'.
There are 836838 rows in 7612 pages for object 'Cash Matching Process'.
DBCC results for 'RD_CYCLE'.
There are 55 rows in 1 pages for object 'RD_CYCLE'.
DBCC results for 'WO_STAT_RULES'.
There are 0 rows in 0 pages for object 'WO_STAT_RULES'.
DBCC results for 'REASON_CD'.
There are 0 rows in 0 pages for object 'REASON_CD'.
DBCC results for 'WO_TYP'.
There are 0 rows in 0 pages for object 'WO_TYP'.
DBCC results for 'COLCT_RULES'.
There are 30 rows in 1 pages for object 'COLCT_RULES'.
DBCC results for 'RECEIPTS_BTCH'.
There are 2109 rows in 44 pages for object 'RECEIPTS_BTCH'.
DBCC results for 'nightly107'.
There are 344086 rows in 3225 pages for object 'nightly107'.
DBCC results for 'WO_TYP_ACT_STAT'.
There are 0 rows in 0 pages for object 'WO_TYP_ACT_STAT'.
DBCC results for 'COMPONENT_MASTER'.
There are 0 rows in 0 pages for object 'COMPONENT_MASTER'.
DBCC results for 'RECEIPTS_I_FILE'.
There are 51698 rows in 3244 pages for object 'RECEIPTS_I_FILE'.
DBCC results for 'NightCash10-12'.
There are 64657 rows in 592 pages for object 'NightCash10-12'.
DBCC results for 'WRK_CENTER_WRK_SCH'.
There are 0 rows in 0 pages for object 'WRK_CENTER_WRK_SCH'.
DBCC results for 'CONS_SVC_CONN_CD'.
There are 1524 rows in 20 pages for object 'CONS_SVC_CONN_CD'.
DBCC results for 'RECEIPT_ITM'.
There are 151581 rows in 6334 pages for object 'RECEIPT_ITM'.
DBCC results for 'Utiligy Cash Match Trace'.
There are 321627 rows in 2928 pages for object 'Utiligy Cash Match Trace'.
DBCC results for 'WRTOFF_GL_CLASS_CD'.
There are 0 rows in 0 pages for object 'WRTOFF_GL_CLASS_CD'.
DBCC results for 'CONTACT_INFO'.
There are 1 rows in 1 pages for object 'CONTACT_INFO'.
DBCC results for 'REFUND_HISTORY'.
There are 906 rows in 24 pages for object 'REFUND_HISTORY'.
DBCC results for 'RECEIPTS_I_FILE2'.
There are 48343 rows in 3022 pages for object 'RECEIPTS_I_FILE2'.
DBCC results for 'CUST_ADDR_REL'.
There are 70611 rows in 2258 pages for object 'CUST_ADDR_REL'.
DBCC results for 'REPORT_TYPE'.
There are 42 rows in 1 pages for object 'REPORT_TYPE'.
DBCC results for 'CUST_CNTRCT_RELSHP'.
There are 0 rows in 0 pages for object 'CUST_CNTRCT_RELSHP'.
DBCC results for 'REQ_READ_SCH'.
There are 1 rows in 1 pages for object 'REQ_READ_SCH'.
DBCC results for 'RESOURCE_ASGNDS'.
There are 0 rows in 0 pages for object 'RESOURCE_ASGNDS'.
DBCC results for 'CUST_INFO'.
There are 36779 rows in 2480 pages for object 'CUST_INFO'.
DBCC results for 'RESOURCE_MASTER'.
There are 0 rows in 0 pages for object 'RESOURCE_MASTER'.
DBCC results for 'RESOURCE_WORK_SCH'.
There are 0 rows in 0 pages for object 'RESOURCE_WORK_SCH'.
DBCC results for 'CUST_PYMT_ACCT'.
There are 0 rows in 0 pages for object 'CUST_PYMT_ACCT'.
DBCC results for 'ROUTE'.
There are 95 rows in 2 pages for object 'ROUTE'.
DBCC results for 'ADDR'.
There are 70767 rows in 861 pages for object 'ADDR'.
DBCC results for 'CUST_STMT_HST'.
There are 0 rows in 0 pages for object 'CUST_STMT_HST'.
DBCC results for 'ROUTE_RD_CYCLE'.
There are 0 rows in 0 pages for object 'ROUTE_RD_CYCLE'.
DBCC results for 'AGING_DAYS_TBL'.
There are 5 rows in 1 pages for object 'AGING_DAYS_TBL'.
DBCC results for 'CUST_SVC_RELSHP'.
There are 73551 rows in 1415 pages for object 'CUST_SVC_RELSHP'.
DBCC results for 'RPT_TYPE_CRITERIA'.
There are 116 rows in 2 pages for object 'RPT_TYPE_CRITERIA'.
DBCC results for 'AMX_MSG_LG'.
There are 0 rows in 0 pages for object 'AMX_MSG_LG'.
DBCC results for 'RPT_VERSION'.
There are 32 rows in 1 pages for object 'RPT_VERSION'.
DBCC results for 'DED_MTR_CONSUM'.
There are 0 rows in 0 pages for object 'DED_MTR_CONSUM'.
DBCC results for 'ASGND_BILL_CAT_CD'.
There are 0 rows in 0 pages for object 'ASGND_BILL_CAT_CD'.
DBCC results for 'RPT_VRSN_CRITERIA'.
There are 15 rows in 1 pages for object 'RPT_VRSN_CRITERIA'.
DBCC results for 'DED_MTR_POS'.
There are 0 rows in 0 pages for object 'DED_MTR_POS'.
DBCC results for 'ASGND_CUST_CAT_CD'.
There are 0 rows in 0 pages for object 'ASGND_CUST_CAT_CD'.
DBCC results for 'SCH_POOL'.
There are 0 rows in 0 pages for object 'SCH_POOL'.
DBCC results for 'DED_MTR_RDING_HIST'.
There are 0 rows in 0 pages for object 'DED_MTR_RDING_HIST'.
CHECKDB found 0 allocation errors and 17 consistency errors in database 'UtiligyPD'.
repair_allow_data_loss is the minimum repair level for the errors found by DBCC CHECKDB (UtiligyPD ).
DBCC execution completed. If DBCC printed error messages, contact your system administrator.


Thanks!
Anita

View 5 Replies View Related

Data Consistency Issue

Jan 15, 2007

Hello Experts,

Posted initial issue under following ID.
http://sqlteam.com/forums/topic.asp?TOPIC_ID=77603

Here is output produced by DBCC CHECKDB

Server: Msg 8952, Level 16, State 1, Line 1
Table error: Database 'dbS_CoreData', index 'cur_Note.NCTNoteId' (ID 246291937) (index ID 4). Extra or invalid key for the keys:
Server: Msg 8956, Level 16, State 1, Line 1
Index row (1:15190:8) with values (ICP = '0001852451QTBA3' and RoundID = '447902G07' and TaskNoteID = '0001852451QTBA3-A' and ? = NULL) points to the data row identified by ().
Server: Msg 8952, Level 16, State 1, Line 1
Table error: Database 'dbS_CoreData', index 'cur_Note.NCTNoteId' (ID 246291937) (index ID 4). Extra or invalid key for the keys:
Server: Msg 8956, Level 16, State 1, Line 1
Index row (1:15190:9) with values (ICP = '0001852451QTBA3' and RoundID = '447902G07' and TaskNoteID = '0001852451QTBA3-B' and ? = NULL) points to the data row identified by ().
Server: Msg 8952, Level 16, State 1, Line 1
Table error: Database 'dbS_CoreData', index 'cur_Note.NCTNoteId' (ID 246291937) (index ID 4). Extra or invalid key for the keys:
Server: Msg 8956, Level 16, State 1, Line 1
Index row (1:15190:10) with values (ICP = '0001852451QTBA3' and RoundID = '447902G07' and TaskNoteID = '0001852451QTBA3-C' and ? = NULL) points to the data row identified by ().
Server: Msg 8952, Level 16, State 1, Line 1
Table error: Database 'dbS_CoreData', index 'cur_Note.NCTNoteId' (ID 246291937) (index ID 4). Extra or invalid key for the keys:
Server: Msg 8956, Level 16, State 1, Line 1
Index row (1:15190:11) with values (ICP = '0001852451QTBA3' and RoundID = '447902G07' and TaskNoteID = '0001852451QTBA3-D' and ? = NULL) points to the data row identified by ().
Server: Msg 8952, Level 16, State 1, Line 1
Table error: Database 'dbS_CoreData', index 'cur_Note.NCTNoteId' (ID 246291937) (index ID 4). Extra or invalid key for the keys:
Server: Msg 8956, Level 16, State 1, Line 1
Index row (1:15190:12) with values (ICP = '0001852451QTBA3' and RoundID = '447902G07' and TaskNoteID = '0001852451QTBA3-E' and ? = NULL) points to the data row identified by ().
Server: Msg 8952, Level 16, State 1, Line 1
Table error: Database 'dbS_CoreData', index 'cur_Note.NCTNoteId' (ID 246291937) (index ID 4). Extra or invalid key for the keys:
Server: Msg 8956, Level 16, State 1, Line 1
Index row (1:15190:13) with values (ICP = '0001852451QTBA3' and RoundID = '447902G07' and TaskNoteID = '0001852451QTBA3-F' and ? = NULL) points to the data row identified by ().
Server: Msg 8952, Level 16, State 1, Line 1
Table error: Database 'dbS_CoreData', index 'cur_Note.NCTNoteId' (ID 246291937) (index ID 4). Extra or invalid key for the keys:
Server: Msg 8956, Level 16, State 1, Line 1
Index row (1:15190:14) with values (ICP = '0001852651QT1A4' and RoundID = '447902G07' and TaskNoteID = '0001852651QT1A4-A' and ? = NULL) points to the data row identified by ().
Server: Msg 8952, Level 16, State 1, Line 1
Table error: Database 'dbS_CoreData', index 'cur_Note.NCTNoteId' (ID 246291937) (index ID 4). Extra or invalid key for the keys:
Server: Msg 8956, Level 16, State 1, Line 1
Index row (1:15190:15) with values (ICP = '0001852651QT1A4' and RoundID = '447902G07' and TaskNoteID = '0001852651QT1A4-B' and ? = NULL) points to the data row identified by ().
Server: Msg 8952, Level 16, State 1, Line 1
Table error: Database 'dbS_CoreData', index 'cur_Note.NCTNoteId' (ID 246291937) (index ID 4). Extra or invalid key for the keys:
Server: Msg 8956, Level 16, State 1, Line 1
Index row (1:15190:16) with values (ICP = '0001852651QT1A4' and RoundID = '447902G07' and TaskNoteID = '0001852651QT1A4-C' and ? = NULL) points to the data row identified by ().
Server: Msg 8952, Level 16, State 1, Line 1
Table error: Database 'dbS_CoreData', index 'cur_Note.NCTNoteId' (ID 246291937) (index ID 4). Extra or invalid key for the keys:
Server: Msg 8956, Level 16, State 1, Line 1
Index row (1:150976:38) with values (ICP = '0001616441QT60D' and RoundID = '447902G07' and TaskNoteID = '0001616441QT60D-A' and ? = NULL) points to the data row identified by ().
Server: Msg 8952, Level 16, State 1, Line 1
Table error: Database 'dbS_CoreData', index 'cur_Note.NCTNoteId' (ID 246291937) (index ID 4). Extra or invalid key for the keys:
Server: Msg 8956, Level 16, State 1, Line 1
Index row (1:150976:39) with values (ICP = '0001616441QT60D' and RoundID = '447902G07' and TaskNoteID = '0001616441QT60D-B' and ? = NULL) points to the data row identified by ().
Server: Msg 8952, Level 16, State 1, Line 1
Table error: Database 'dbS_CoreData', index 'cur_Note.NCTNoteId' (ID 246291937) (index ID 4). Extra or invalid key for the keys:
Server: Msg 8956, Level 16, State 1, Line 1
Index row (1:150976:40) with values (ICP = '0001616441QT60D' and RoundID = '447902G07' and TaskNoteID = '0001616441QT60D-C' and ? = NULL) points to the data row identified by ().
Server: Msg 8952, Level 16, State 1, Line 1
Table error: Database 'dbS_CoreData', index 'cur_Note.NCTNoteId' (ID 246291937) (index ID 4). Extra or invalid key for the keys:
Server: Msg 8956, Level 16, State 1, Line 1
Index row (1:150976:41) with values (ICP = '0001616441QT60D' and RoundID = '447902G07' and TaskNoteID = '0001616441QT60D-D' and ? = NULL) points to the data row identified by ().
Server: Msg 8952, Level 16, State 1, Line 1
Table error: Database 'dbS_CoreData', index 'cur_Note.NCTNoteId' (ID 246291937) (index ID 4). Extra or invalid key for the keys:
Server: Msg 8956, Level 16, State 1, Line 1
Index row (1:150976:42) with values (ICP = '0001616441QT60D' and RoundID = '447902G07' and TaskNoteID = '0001616441QT60D-E' and ? = NULL) points to the data row identified by ().
Server: Msg 8952, Level 16, State 1, Line 1
Table error: Database 'dbS_CoreData', index 'cur_Note.NCTNoteId' (ID 246291937) (index ID 4). Extra or invalid key for the keys:
Server: Msg 8956, Level 16, State 1, Line 1
Index row (1:150976:43) with values (ICP = '0001616441QT60D' and RoundID = '447902G07' and TaskNoteID = '0001616441QT60D-F' and ? = NULL) points to the data row identified by ().
Server: Msg 8952, Level 16, State 1, Line 1
Table error: Database 'dbS_CoreData', index 'cur_Note.NCTNoteId' (ID 246291937) (index ID 4). Extra or invalid key for the keys:
Server: Msg 8956, Level 16, State 1, Line 1
Index row (1:150976:44) with values (ICP = '0001616441QT60D' and RoundID = '447902G07' and TaskNoteID = '0001616441QT60D-G' and ? = NULL) points to the data row identified by ().
Server: Msg 8952, Level 16, State 1, Line 1
Table error: Database 'dbS_CoreData', index 'cur_Note.NCTNoteId' (ID 246291937) (index ID 4). Extra or invalid key for the keys:
Server: Msg 8956, Level 16, State 1, Line 1
Index row (1:151052:0) with values (ICP = '0001812701QTB3D' and RoundID = '447902G07' and TaskNoteID = '0001812701QTB3D-A' and ? = NULL) points to the data row identified by ().
Server: Msg 8952, Level 16, State 1, Line 1
Table error: Database 'dbS_CoreData', index 'cur_Note.NCTNoteId' (ID 246291937) (index ID 4). Extra or invalid key for the keys:
Server: Msg 8956, Level 16, State 1, Line 1
Index row (1:151052:1) with values (ICP = '0001812701QTB3D' and RoundID = '447902G07' and TaskNoteID = '0001812701QTB3D-B' and ? = NULL) points to the data row identified by ().
Server: Msg 8952, Level 16, State 1, Line 1
Table error: Database 'dbS_CoreData', index 'cur_Note.NCTNoteId' (ID 246291937) (index ID 4). Extra or invalid key for the keys:
Server: Msg 8956, Level 16, State 1, Line 1
Index row (1:151052:2) with values (ICP = '0001812701QTB3D' and RoundID = '447902G07' and TaskNoteID = '0001812701QTB3D-C' and ? = NULL) points to the data row identified by ().
Server: Msg 8952, Level 16, State 1, Line 1
Table error: Database 'dbS_CoreData', index 'cur_Note.NCTNoteId' (ID 246291937) (index ID 4). Extra or invalid key for the keys:
Server: Msg 8956, Level 16, State 1, Line 1
Index row (1:173530:7) with values (ICP = '0001847891QTF81' and RoundID = '447902G07' and TaskNoteID = '0001847891QTF81-A' and ? = NULL) points to the data row identified by ().
Server: Msg 8952, Level 16, State 1, Line 1
Table error: Database 'dbS_CoreData', index 'cur_Note.NCTNoteId' (ID 246291937) (index ID 4). Extra or invalid key for the keys:
Server: Msg 8956, Level 16, State 1, Line 1
Index row (1:173530:8) with values (ICP = '0001847891QTF81' and RoundID = '447902G07' and TaskNoteID = '0001847891QTF81-B' and ? = NULL) points to the data row identified by ().
Server: Msg 8952, Level 16, State 1, Line 1
Table error: Database 'dbS_CoreData', index 'cur_Note.NCTNoteId' (ID 246291937) (index ID 4). Extra or invalid key for the keys:
Server: Msg 8956, Level 16, State 1, Line 1
Index row (1:173530:9) with values (ICP = '0001847891QTF81' and RoundID = '447902G07' and TaskNoteID = '0001847891QTF81-C' and ? = NULL) points to the data row identified by ().
Server: Msg 8952, Level 16, State 1, Line 1
Table error: Database 'dbS_CoreData', index 'cur_Note.NCTNoteId' (ID 246291937) (index ID 4). Extra or invalid key for the keys:
Server: Msg 8956, Level 16, State 1, Line 1
Index row (1:173530:10) with values (ICP = '0001847891QTF81' and RoundID = '447902G07' and TaskNoteID = '0001847891QTF81-D' and ? = NULL) points to the data row identified by ().
Server: Msg 8952, Level 16, State 1, Line 1
Table error: Database 'dbS_CoreData', index 'cur_Note.NCTNoteId' (ID 246291937) (index ID 4). Extra or invalid key for the keys:
Server: Msg 8956, Level 16, State 1, Line 1
Index row (1:173530:11) with values (ICP = '0001847891QTF81' and RoundID = '447902G07' and TaskNoteID = '0001847891QTF81-E' and ? = NULL) points to the data row identified by ().
Server: Msg 8952, Level 16, State 1, Line 1
Table error: Database 'dbS_CoreData', index 'cur_Note.NCTNoteId' (ID 246291937) (index ID 4). Extra or invalid key for the keys:
Server: Msg 8956, Level 16, State 1, Line 1
Index row (1:173530:12) with values (ICP = '0001847891QTF81' and RoundID = '447902G07' and TaskNoteID = '0001847891QTF81-F' and ? = NULL) points to the data row identified by ().
Server: Msg 8952, Level 16, State 1, Line 1
Table error: Database 'dbS_CoreData', index 'cur_Note.NCTNoteId' (ID 246291937) (index ID 4). Extra or invalid key for the keys:
Server: Msg 8956, Level 16, State 1, Line 1
Index row (1:254182:0) with values (ICP = '0001844261QT77C' and RoundID = '447902G07' and TaskNoteID = '0001844261QT77C-A' and ? = NULL) points to the data row identified by ().
Server: Msg 8952, Level 16, State 1, Line 1
Table error: Database 'dbS_CoreData', index 'cur_Note.NCTNoteId' (ID 246291937) (index ID 4). Extra or invalid key for the keys:
Server: Msg 8956, Level 16, State 1, Line 1
Index row (1:254182:1) with values (ICP = '0001844261QT77C' and RoundID = '447902G07' and TaskNoteID = '0001844261QT77C-B' and ? = NULL) points to the data row identified by ().
Server: Msg 8952, Level 16, State 1, Line 1
Table error: Database 'dbS_CoreData', index 'cur_Note.NCTNoteId' (ID 246291937) (index ID 4). Extra or invalid key for the keys:
Server: Msg 8956, Level 16, State 1, Line 1
Index row (1:254182:2) with values (ICP = '0001844261QT77C' and RoundID = '447902G07' and TaskNoteID = '0001844261QT77C-C' and ? = NULL) points to the data row identified by ().
Server: Msg 8952, Level 16, State 1, Line 1
Table error: Database 'dbS_CoreData', index 'cur_Note.NCTNoteId' (ID 246291937) (index ID 4). Extra or invalid key for the keys:
Server: Msg 8956, Level 16, State 1, Line 1
Index row (1:254182:3) with values (ICP = '0001844261QT77C' and RoundID = '447902G07' and TaskNoteID = '0001844261QT77C-D' and ? = NULL) points to the data row identified by ().
Server: Msg 8952, Level 16, State 1, Line 1
Table error: Database 'dbS_CoreData', index 'cur_Note.NCTNoteId' (ID 246291937) (index ID 4). Extra or invalid key for the keys:
Server: Msg 8956, Level 16, State 1, Line 1
Index row (1:254182:4) with values (ICP = '0001844261QT77C' and RoundID = '447902G07' and TaskNoteID = '0001844261QT77C-E' and ? = NULL) points to the data row identified by ().
Server: Msg 8952, Level 16, State 1, Line 1
Table error: Database 'dbS_CoreData', index 'cur_Note.NCTNoteId' (ID 246291937) (index ID 4). Extra or invalid key for the keys:
Server: Msg 8956, Level 16, State 1, Line 1
Index row (1:254182:5) with values (ICP = '0001844261QT77C' and RoundID = '447902G07' and TaskNoteID = '0001844261QT77C-F' and ? = NULL) points to the data row identified by ().
Server: Msg 8952, Level 16, State 1, Line 1
Table error: Database 'dbS_CoreData', index 'cur_Note.NCTNoteId' (ID 246291937) (index ID 4). Extra or invalid key for the keys:
Server: Msg 8956, Level 16, State 1, Line 1
Index row (1:464181:0) with values (ICP = '0001826311QTA3D' and RoundID = '447902G07' and TaskNoteID = '0001826311QTA3D-E' and ? = NULL) points to the data row identified by ().
Server: Msg 8952, Level 16, State 1, Line 1
Table error: Database 'dbS_CoreData', index 'cur_Note.NCTNoteId' (ID 246291937) (index ID 4). Extra or invalid key for the keys:
Server: Msg 8956, Level 16, State 1, Line 1
Index row (1:464181:1) with values (ICP = '0001826311QTA3D' and RoundID = '447902G07' and TaskNoteID = '0001826311QTA3D-F' and ? = NULL) points to the data row identified by ().
Server: Msg 8952, Level 16, State 1, Line 1
Table error: Database 'dbS_CoreData', index 'cur_Note.NCTNoteId' (ID 246291937) (index ID 4). Extra or invalid key for the keys:
Server: Msg 8956, Level 16, State 1, Line 1
Index row (1:637371:0) with values (ICP = '0001820381QT01A' and RoundID = '447902G07' and TaskNoteID = '0001820381QT01A-A' and ? = NULL) points to the data row identified by ().
Server: Msg 8952, Level 16, State 1, Line 1
Table error: Database 'dbS_CoreData', index 'cur_Note.NCTNoteId' (ID 246291937) (index ID 4). Extra or invalid key for the keys:
Server: Msg 8956, Level 16, State 1, Line 1
Index row (1:637371:1) with values (ICP = '0001820381QT01A' and RoundID = '447902G07' and TaskNoteID = '0001820381QT01A-B' and ? = NULL) points to the data row identified by ().
Server: Msg 8952, Level 16, State 1, Line 1
Table error: Database 'dbS_CoreData', index 'cur_Note.NCTNoteId' (ID 246291937) (index ID 4). Extra or invalid key for the keys:
Server: Msg 8956, Level 16, State 1, Line 1
Index row (1:637371:2) with values (ICP = '0001820381QT01A' and RoundID = '447902G07' and TaskNoteID = '0001820381QT01A-C' and ? = NULL) points to the data row identified by ().
Server: Msg 8952, Level 16, State 1, Line 1
Table error: Database 'dbS_CoreData', index 'cur_Note.NCTNoteId' (ID 246291937) (index ID 4). Extra or invalid key for the keys:
Server: Msg 8956, Level 16, State 1, Line 1
Index row (1:637371:3) with values (ICP = '0001820381QT01A' and RoundID = '447902G07' and TaskNoteID = '0001820381QT01A-D' and ? = NULL) points to the data row identified by ().
Server: Msg 8952, Level 16, State 1, Line 1
Table error: Database 'dbS_CoreData', index 'cur_Note.NCTNoteId' (ID 246291937) (index ID 4). Extra or invalid key for the keys:
Server: Msg 8956, Level 16, State 1, Line 1
Index row (1:637371:4) with values (ICP = '0001820381QT01A' and RoundID = '447902G07' and TaskNoteID = '0001820381QT01A-E' and ? = NULL) points to the data row identified by ().
Server: Msg 8952, Level 16, State 1, Line 1
Table error: Database 'dbS_CoreData', index 'cur_Note.NCTNoteId' (ID 246291937) (index ID 4). Extra or invalid key for the keys:
Server: Msg 8956, Level 16, State 1, Line 1
Index row (1:637371:5) with values (ICP = '0001820381QT01A' and RoundID = '447902G07' and TaskNoteID = '0001820381QT01A-F' and ? = NULL) points to the data row identified by ().
Server: Msg 8952, Level 16, State 1, Line 1
Table error: Database 'dbS_CoreData', index 'cur_Note.NCTNoteId' (ID 246291937) (index ID 4). Extra or invalid key for the keys:
Server: Msg 8956, Level 16, State 1, Line 1
Index row (1:637371:6) with values (ICP = '0001820381QT01A' and RoundID = '447902G07' and TaskNoteID = '0001820381QT01A-G' and ? = NULL) points to the data row identified by ().
Server: Msg 8952, Level 16, State 1, Line 1
Table error: Database 'dbS_CoreData', index 'cur_Note.NCTNoteId' (ID 246291937) (index ID 4). Extra or invalid key for the keys:
Server: Msg 8956, Level 16, State 1, Line 1
Index row (1:637371:7) with values (ICP = '0001820381QT01A' and RoundID = '447902G07' and TaskNoteID = '0001820381QT01A-H' and ? = NULL) points to the data row identified by ().
Server: Msg 8952, Level 16, State 1, Line 1
Table error: Database 'dbS_CoreData', index 'cur_Note.NCTNoteId' (ID 246291937) (index ID 4). Extra or invalid key for the keys:
Server: Msg 8956, Level 16, State 1, Line 1
Index row (1:854751:0) with values (ICP = '0001803181QT130' and RoundID = '447902G07' and TaskNoteID = '0001803181QT130-A' and ? = NULL) points to the data row identified by ().
Server: Msg 8952, Level 16, State 1, Line 1
Table error: Database 'dbS_CoreData', index 'cur_Note.NCTNoteId' (ID 246291937) (index ID 4). Extra or invalid key for the keys:
Server: Msg 8956, Level 16, State 1, Line 1
Index row (1:854751:1) with values (ICP = '0001803181QT130' and RoundID = '447902G07' and TaskNoteID = '0001803181QT130-B' and ? = NULL) points to the data row identified by ().
Server: Msg 8952, Level 16, State 1, Line 1
Table error: Database 'dbS_CoreData', index 'cur_Note.NCTNoteId' (ID 246291937) (index ID 4). Extra or invalid key for the keys:
Server: Msg 8956, Level 16, State 1, Line 1
Index row (1:854751:2) with values (ICP = '0001803181QT130' and RoundID = '447902G07' and TaskNoteID = '0001803181QT130-C' and ? = NULL) points to the data row identified by ().
Server: Msg 8952, Level 16, State 1, Line 1
Table error: Database 'dbS_CoreData', index 'cur_Note.NCTNoteId' (ID 246291937) (index ID 4). Extra or invalid key for the keys:
Server: Msg 8956, Level 16, State 1, Line 1
Index row (1:854751:3) with values (ICP = '0001803181QT130' and RoundID = '447902G07' and TaskNoteID = '0001803181QT130-D' and ? = NULL) points to the data row identified by ().
Server: Msg 8952, Level 16, State 1, Line 1
Table error: Database 'dbS_CoreData', index 'cur_Note.NCTNoteId' (ID 246291937) (index ID 4). Extra or invalid key for the keys:
Server: Msg 8956, Level 16, State 1, Line 1
Index row (1:854751:4) with values (ICP = '0001803181QT130' and RoundID = '447902G07' and TaskNoteID = '0001803181QT130-E' and ? = NULL) points to the data row identified by ().
Server: Msg 8952, Level 16, State 1, Line 1
Table error: Database 'dbS_CoreData', index 'cur_Note.NCTNoteId' (ID 246291937) (index ID 4). Extra or invalid key for the keys:
Server: Msg 8956, Level 16, State 1, Line 1
Index row (1:854751:5) with values (ICP = '0001803181QT130' and RoundID = '447902G07' and TaskNoteID = '0001803181QT130-F' and ? = NULL) points to the data row identified by ().
Server: Msg 8952, Level 16, State 1, Line 1
Table error: Database 'dbS_CoreData', index 'cur_Note.NCTNoteId' (ID 246291937) (index ID 4). Extra or invalid key for the keys:
Server: Msg 8956, Level 16, State 1, Line 1
Index row (1:854751:6) with values (ICP = '0001803181QT130' and RoundID = '447902G07' and TaskNoteID = '0001803181QT130-G' and ? = NULL) points to the data row identified by ().
Server: Msg 8952, Level 16, State 1, Line 1
Table error: Database 'dbS_CoreData', index 'cur_Note.NCTNoteId' (ID 246291937) (index ID 4). Extra or invalid key for the keys:
Server: Msg 8956, Level 16, State 1, Line 1
Index row (1:854751:7) with values (ICP = '0001803181QT130' and RoundID = '447902G07' and TaskNoteID = '0001803181QT130-H' and ? = NULL) points to the data row identified by ().
Server: Msg 8952, Level 16, State 1, Line 1
Table error: Database 'dbS_CoreData', index 'cur_Note.NCTNoteId' (ID 246291937) (index ID 4). Extra or invalid key for the keys:
Server: Msg 8956, Level 16, State 1, Line 1
Index row (1:854751:8) with values (ICP = '0001803181QT130' and RoundID = '447902G07' and TaskNoteID = '0001803181QT130-I' and ? = NULL) points to the data row identified by ().
Server: Msg 8952, Level 16, State 1, Line 1
Table error: Database 'dbS_CoreData', index 'cur_Note.NCTNoteId' (ID 246291937) (index ID 4). Extra or invalid key for the keys:
Server: Msg 8956, Level 16, State 1, Line 1
Index row (1:941618:3) with values (ICP = '0001826311QTA3D' and RoundID = '447902G07' and TaskNoteID = '0001826311QTA3D-A' and ? = NULL) points to the data row identified by ().
Server: Msg 8952, Level 16, State 1, Line 1
Table error: Database 'dbS_CoreData', index 'cur_Note.NCTNoteId' (ID 246291937) (index ID 4). Extra or invalid key for the keys:
Server: Msg 8956, Level 16, State 1, Line 1
Index row (1:941618:4) with values (ICP = '0001826311QTA3D' and RoundID = '447902G07' and TaskNoteID = '0001826311QTA3D-B' and ? = NULL) points to the data row identified by ().
Server: Msg 8952, Level 16, State 1, Line 1
Table error: Database 'dbS_CoreData', index 'cur_Note.NCTNoteId' (ID 246291937) (index ID 4). Extra or invalid key for the keys:
Server: Msg 8956, Level 16, State 1, Line 1
Index row (1:941618:5) with values (ICP = '0001826311QTA3D' and RoundID = '447902G07' and TaskNoteID = '0001826311QTA3D-C' and ? = NULL) points to the data row identified by ().
Server: Msg 8952, Level 16, State 1, Line 1
Table error: Database 'dbS_CoreData', index 'cur_Note.NCTNoteId' (ID 246291937) (index ID 4). Extra or invalid key for the keys:
Server: Msg 8956, Level 16, State 1, Line 1
Index row (1:941618:6) with values (ICP = '0001826311QTA3D' and RoundID = '447902G07' and TaskNoteID = '0001826311QTA3D-D' and ? = NULL) points to the data row identified by ().
DBCC results for 'dbS_CoreData'.
DBCC results for 'sysobjects'.
There are 341 rows in 6 pages for object 'sysobjects'.
DBCC results for 'sysindexes'.
There are 610 rows in 42 pages for object 'sysindexes'.
DBCC results for 'syscolumns'.
There are 2035 rows in 41 pages for object 'syscolumns'.
DBCC results for 'systypes'.
There are 26 rows in 1 pages for object 'systypes'.
DBCC results for 'syscomments'.
There are 348 rows in 94 pages for object 'syscomments'.
DBCC results for 'sysfiles1'.
There are 2 rows in 1 pages for object 'sysfiles1'.
DBCC results for 'syspermissions'.
There are 116 rows in 1 pages for object 'syspermissions'.
DBCC results for 'sysusers'.
There are 16 rows in 1 pages for object 'sysusers'.
DBCC results for 'sysproperties'.
There are 5 rows in 2 pages for object 'sysproperties'.
DBCC results for 'sysdepends'.
There are 2690 rows in 15 pages for object 'sysdepends'.
DBCC results for 'sysreferences'.
There are 22 rows in 1 pages for object 'sysreferences'.
DBCC results for 'sysfulltextcatalogs'.
There are 0 rows in 0 pages for object 'sysfulltextcatalogs'.
DBCC results for 'sysfulltextnotify'.
There are 0 rows in 0 pages for object 'sysfulltextnotify'.
DBCC results for 'sysfilegroups'.
There are 1 rows in 1 pages for object 'sysfilegroups'.
DBCC results for 'tmp_KCE_Eval_Round'.
There are 1 rows in 1 pages for object 'tmp_KCE_Eval_Round'.
DBCC results for 'tmp_KCE_Eval_Property'.
There are 20 rows in 1 pages for object 'tmp_KCE_Eval_Property'.
DBCC results for 'tmp_KCE_Eval_Task'.
There are 33 rows in 2 pages for object 'tmp_KCE_Eval_Task'.
DBCC results for 'tmp_KCE_Eval_Note'.
There are 113 rows in 3 pages for object 'tmp_KCE_Eval_Note'.
DBCC results for 'tmp_KCE_Train_Round'.
There are 1 rows in 1 pages for object 'tmp_KCE_Train_Round'.
DBCC results for 'tmp_KCE_Train_Property'.
There are 30 rows in 1 pages for object 'tmp_KCE_Train_Property'.
DBCC results for 'tmp_KCE_Train_Task'.
There are 38 rows in 2 pages for object 'tmp_KCE_Train_Task'.
DBCC results for 'dlg_TeamCodes'.
There are 34 rows in 1 pages for object 'dlg_TeamCodes'.
DBCC results for 'cur_Round'.
There are 894 rows in 39 pages for object 'cur_Round'.
DBCC results for 'tmp_KCE_Train_Note'.
There are 160 rows in 4 pages for object 'tmp_KCE_Train_Note'.
DBCC results for 'dlg_Users'.
There are 397 rows in 16 pages for object 'dlg_Users'.
DBCC results for 'cur_Property'.
There are 92033 rows in 6880 pages for object 'cur_Property'.
DBCC results for 'cur_Task'.
There are 125253 rows in 9057 pages for object 'cur_Task'.
DBCC results for 'cur_Note'.
There are 339746 rows in 14089 pages for object 'cur_Note'.
CHECKDB found 0 allocation errors and 54 consistency errors in table 'cur_Note' (object ID 246291937).
DBCC results for 'arc_Note'.
There are 15609480 rows in 310776 pages for object 'arc_Note'.
DBCC results for 'arc_FieldNote'.
There are 1633726 rows in 41597 pages for object 'arc_FieldNote'.
DBCC results for 'dlg_UserTasks'.
There are 3116 rows in 39 pages for object 'dlg_UserTasks'.
DBCC results for 'dlg_ImportDetails'.
There are 1958 rows in 36 pages for object 'dlg_ImportDetails'.
DBCC results for 'arc_Property'.
There are 3729453 rows in 128092 pages for object 'arc_Property'.
DBCC results for 'arc_Round'.
There are 99219 rows in 2010 pages for object 'arc_Round'.
DBCC results for 'arc_Task'.
There are 5445171 rows in 185259 pages for object 'arc_Task'.
DBCC results for 'cur_FieldNote'.
There are 5647 rows in 242 pages for object 'cur_FieldNote'.
DBCC results for 'dlg_tmpAddZone'.
There are 0 rows in 15 pages for object 'dlg_tmpAddZone'.
DBCC results for 'dlg_Clients'.
There are 30 rows in 1 pages for object 'dlg_Clients'.
DBCC results for 'GenesisCheckReads'.
There are 13932 rows in 277 pages for object 'GenesisCheckReads'.
DBCC results for 'tmp_Duplicate_Tasks'.
There are 3947 rows in 127 pages for object 'tmp_Duplicate_Tasks'.
DBCC results for 'log_RoundActivity'.
There are 429434 rows in 5074 pages for object 'log_RoundActivity'.
DBCC results for 'copy_cur_Task'.
There are 138705 rows in 4439 pages for object 'copy_cur_Task'.
DBCC results for 'RoundTable'.
There are 5419 rows in 43 pages for object 'RoundTable'.
DBCC results for 'dlg_TaskTypes'.
There are 15 rows in 1 pages for object 'dlg_TaskTypes'.
DBCC results for 'log_Activity'.
There are 458463 rows in 9322 pages for object 'log_Activity'.
DBCC results for 'lib_RoundPerformance'.
There are 99387 rows in 2601 pages for object 'lib_RoundPerformance'.
DBCC results for 'dlg_SysUtilsRoundsRef'.
There are 1 rows in 1 pages for object 'dlg_SysUtilsRoundsRef'.
DBCC results for 'khutemp'.
There are 19747 rows in 470 pages for object 'khutemp'.
DBCC results for 'tmp_TempICPs'.
There are 14 rows in 1 pages for object 'tmp_TempICPs'.
DBCC results for 'dlg_Holidays'.
There are 53 rows in 1 pages for object 'dlg_Holidays'.
DBCC results for 'log_Comms'.
There are 2168949 rows in 73621 pages for object 'log_Comms'.
DBCC results for 'dlg_RefRound'.
There are 196 rows in 1 pages for object 'dlg_RefRound'.
DBCC results for 'Temp_RFICP'.
There are 38 rows in 1 pages for object 'Temp_RFICP'.
DBCC results for 'dlg_AreaCodes'.
There are 62 rows in 1 pages for object 'dlg_AreaCodes'.
DBCC results for 'dlg_GroupDetails'.
There are 350 rows in 5 pages for object 'dlg_GroupDetails'.
DBCC results for 'dlg_Countries'.
There are 3 rows in 1 pages for object 'dlg_Countries'.
DBCC results for 'dlg_Groups'.
There are 18 rows in 1 pages for object 'dlg_Groups'.
DBCC results for 'dlg_DumpResultImport'.
There are 0 rows in 0 pages for object 'dlg_DumpResultImport'.
DBCC results for 'dlg_Companies'.
There are 4 rows in 1 pages for object 'dlg_Companies'.
DBCC results for 'dlg_UserDetails'.
There are 188 rows in 3 pages for object 'dlg_UserDetails'.
DBCC results for 'tmp_EOLUnreadICPs'.
There are 28 rows in 1 pages for object 'tmp_EOLUnreadICPs'.
DBCC results for 'log_Importfiles'.
There are 2022 rows in 145 pages for object 'log_Importfiles'.
DBCC results for 'dlg_UserSecurity'.
There are 188 rows in 2 pages for object 'dlg_UserSecurity'.
DBCC results for 'log_LoginSession'.
There are 2049029 rows in 35632 pages for object 'log_LoginSession'.
DBCC results for 'dlg_DeviceDetails'.
There are 197 rows in 7 pages for object 'dlg_DeviceDetails'.
DBCC results for 'cur_FieldResult'.
There are 23907 rows in 899 pages for object 'cur_FieldResult'.
DBCC results for 'arc_FieldResult'.
There are 5539213 rows in 168533 pages for object 'arc_FieldResult'.
DBCC results for 'dlg_DialogServerLog'.
There are 1442 rows in 33 pages for object 'dlg_DialogServerLog'.
DBCC results for 'dlg_UserZones'.
There are 6484 rows in 56 pages for object 'dlg_UserZones'.
DBCC results for 'log_RPT_Selection_Crieteria'.
There are 64529 rows in 21127 pages for object 'log_RPT_Selection_Crieteria'.
DBCC results for 'log_Communication_Detail'.
There are 8175148 rows in 87720 pages for object 'log_Communication_Detail'.
DBCC results for 'dlg_ZoneCodes'.
There are 2268 rows in 28 pages for object 'dlg_ZoneCodes'.
DBCC results for 'DRQA01MRP'.
There are 83 rows in 2 pages for object 'DRQA01MRP'.
DBCC results for 'tmp_abc'.
There are 3 rows in 1 pages for object 'tmp_abc'.
DBCC results for 'dlg_DumpNoteImport'.
There are 14 rows in 1 pages for object 'dlg_DumpNoteImport'.
DBCC results for 'dlg_FilePaths'.
There are 1 rows in 1 pages for object 'dlg_FilePaths'.
DBCC results for 'dlg_MRPErrors'.
There are 296 rows in 12 pages for object 'dlg_MRPErrors'.
DBCC results for 'rpt_SubHeaderInfo'.
There are 46 rows in 3 pages for object 'rpt_SubHeaderInfo'.
DBCC results for 'dlg_SystemUtilities'.
There are 7 rows in 1 pages for object 'dlg_SystemUtilities'.
DBCC results for 'dlg_ErrorLog'.
There are 1401 rows in 49 pages for object 'dlg_ErrorLog'.
DBCC results for 'dlg_ExportDetails'.
There are 69883 rows in 4581 pages for object 'dlg_ExportDetails'.
DBCC results for 'dtproperties'.
There are 28 rows in 1 pages for object 'dtproperties'.
DBCC results for 'dlg_Tasks'.
There are 72 rows in 1 pages for object 'dlg_Tasks'.
DBCC results for 'log_RoundPerform'.
There are 0 rows in 0 pages for object 'log_RoundPerform'.
DBCC results for 'rpt_HeaderInfo'.
There are 4 rows in 1 pages for object 'rpt_HeaderInfo'.
DBCC results for 'dlg_Supervisors'.
There are 1613 rows in 13 pages for object 'dlg_Supervisors'.
CHECKDB found 0 allocation errors and 54 consistency errors in database 'dbS_CoreData'.
repair_fast is the minimum repair level for the errors found by DBCC CHECKDB (dbS_CoreData ).
DBCC execution completed. If DBCC printed error messages, contact your system administrator.



*PLease LET ME KNOW WHAT IS RECOMMENED FURTHER STEP IN ORDER TO ELIMINATE THIS ERROR PERMANENTLY.. THANKS IN ADVANCE.
I am using SQL 2000 WITH sp4.







SKR

View 3 Replies View Related

SQL 2012 :: Adding Article To Existing Transnational Replication?

Aug 5, 2014

In my local environment , i was setup transnational replication then i have added new article by using below script

EXEC sp_changepublication @publication = 'demo', @property =
N'allow_anonymous', @value='TRUE'
Go
EXEC sp_changepublication @publication = 'demo', @property =
N'immediate_sync', @value='TRUE'
EXEC sp_addarticle @publication = 'demo', @article ='employee',

[Code]....

But article not added and showing this error message The initial snapshot for article 'employee' is not yet available.

What is the issue, what can i do to add new article ? What did I mistake?

View 2 Replies View Related

Data Read-Consistency During Update

Sep 27, 2007

Hi folks,I have 3 tables of related data in SQL 2000/2005 that receive periodic adds/updates every 30 seconds.I have enabled transactions on all updates, is anything else needed to ensure data consistency during reads in a high # of fetches per second situation?Thanks,johnEdit:Clarification -- I just need the data to be correctly displayed to all users. 

View 2 Replies View Related

Data Format Consistency Or Query?

Oct 2, 2006

Hi

I have a table that stores the period and year as two seperate fields the problem that i have is that when the data is entered in the data base the period is sometime entered as 6 or 06, hence i have a table thaat looks like as follows:


Period Year
====== ====
6 2006
06 2005
12 2006
3 2005
2 2005
4 2005
04 2005
03 2005



when i currently query the information using the period i use the LIKE command in SQL which gives me the results but the problem is when the like is done with 2 as the period value it also retrieves the 12, 02, and 2, in that case the period 12 was not that was requested.

I was wondering is there a way to reformat the data so that all the data is in a consistent format?

Or is there a better way of quering the information in the current format?

View 13 Replies View Related

AdventureWorks Sample Database &&amp; Data Consistency

Oct 17, 2007

Hi,

I'm working with the sample database called Adventure Works and I'm encountering data consistency issues :
If I sum the TotalDue for one particular territory, for one particular time window from the Sales. SalesOrderHeader table and if I try to compare the result to the LastYearSales and YTDSales from the Sales.SalesTerritory table, I don't get the same number, whatever I try. So did I miss something ?
How are the LastYearSales and YTDSales fields from Sales.SalesTerritory calculated ?

Thx,

Anissa

View 3 Replies View Related

SQL Server Admin 2014 :: Configure Transnational Replication Between Two Different Domains And Non Trusted Domains?

Apr 28, 2014

Is it possible to configure transnational replication between two different domains also non trusted domains.

It's possible means what i need to take care before configure replication and how to configure transnational replication between two different domains.

View 2 Replies View Related

Data Recovery??

May 14, 2001

Hi,
I have SQL 7.0, SP2 running on NT 4.0 with SP5. I have a central publisher and
numerous subscribers using nightly merge push replication. There seems to be some
problem with the rollback after a failed attempt at replication. The publisher
states that there was no response from the sub database and that it was suspect.
From the sql logs on the sub, I can see that the db went into recovery mode,
recovered 100%, howerver all the data in the subscribing database has disappered.
The schema of all the tables is intact and the database still reads at its old
size ~2Gigs. I can't see the data though. The publisher or other subscribers have
suffered no similar loss of data. It seems that there was some sort of error when
the database was trying to rollback to where it was before the attempted
replication. Has anyone experienced anythng similar? Anyone know how I can
recover the data?

I ran a dbcc checkdb, but it reported no errors, saying that there were no rows
in any of my replicated tables.

Any help / suggestions are appreciated.

JC
.

View 2 Replies View Related

Data Recovery

Dec 5, 2002

Hi All!
I made a big mess recently and i need an urgent help. We have 12 months of our company data located in 2 sql servers out of which one server contains 9 months of data (Say A)and another contains 3 months of data (Say B).

The server which contains 9 months data was taken a backup in June 1st week and this is the last backup to the databae in this server.

Now i have tried to append the 3 months data to the 9 months data. So i selected the export option of the B and overlooked the option of "Delete destination objects first".
This creared the disaster. It deleted all our 9 months data in A and wrote down the 3 months data in B.

Now i need to receover the 9 months data in A which was deleted.

Any help please.
I tried with Logexplorer evaluation version but it permitted me to only Northwind and Pubs database.

And also i have tried some other tools like MS SQL Recovery but as evaluation products they didnt helped me completely.

Please let me know if you have any other ideas.
Iam in complete risk, now. :(

Regards,
Satish.

View 4 Replies View Related

Data Recovery

Apr 13, 2002

hi,
we are working on SQL server the tables got accitental deleted .we also dont have a back up of the database If anyone can please help me out with how to get back the data

View 1 Replies View Related

Data Recovery

Jun 30, 1999

Hi there,

IS it possible to recover the database from .Dat files? If we only have the Device files of the old database. Can we import it(Atleast the data in the tables) into the new server?

Thanks in advance

View 1 Replies View Related

Sql Data Recovery?

Dec 1, 2006

To the point....My company received a disc containing our last year's databaseinformation from the online company that we use for our documentation(They use SQL ). Only thing is, we are a small business and do not havea "server", therefore we do not have sql server, therefore we can't getour documentation off of the disc. The thing is, we're beingaccredited next week and I need this information for accreditationpurposes. I need to know if there is another option to retrieve thisinformation without purchasing Microsoft Server and SQL Server.any advice / help would be much appreciated.CRS

View 6 Replies View Related

Recovery :: Server Local High Availability Using Failover Cluster And Disaster Recovery Using AlwaysOn

Aug 17, 2015

We have a requirement to build SQL environment which will give us local high availability and disaster recovery to second site. We have two sites- Site A & Site B. We are planning to have two nodes at Site A and 2 nodes at Site B. All four nodes will be part of same Windows failover cluster. We will build two SQL Cluster, InstanceA will be clustered between the nodes at Site A Server and InstanceB will be clustered between the nodes at Site B, we will enable Always On Between the InstanceA and InstanceB and will be primary owner where data will be written on InstanceA and will be replicated to InstaceB. URL....Now we want we will have instanceC on the Site B and data will be writen from the application available on Site B, will be replicated to the instance on the Site A as replica.

View 6 Replies View Related

SQL Server Admin 2014 :: Is Bulk Logged Recovery Model Support Point In Time Recovery

Dec 23, 2014

is bulk logged recovery model support point in time recovery

View 9 Replies View Related

Recovery :: Pages On A Full Recovery Model Database Corrupted

Sep 17, 2015

Pages on a full recovery model database corrupted, need to ensure data loss is minimal for restore operation am thinking about restoring the latest full backup.

View 4 Replies View Related

Data Recovery From Reinstallation

Jul 25, 2000

I am a newcomer for SQL Server. Yesterday my NT was down, and had to be reinstalled. Therefore SQL Server 7 used has to been reinstalled too. Though old data files for SQL Server still exists, however, reinstalled SQL Server 7 cannot use them directly. I just wonder if there are any method or utility that are able to recover those previous data? Thanks very much in advance.

View 1 Replies View Related

Recovery Data From Transaction Log

Dec 19, 2007

Hi

DepartmentMaster table has been deleted

how can I retrive the data from transaction log?

thanks

View 5 Replies View Related

Data Recovery Service

Dec 19, 2007

I have a client with a badly corrupted SQL database including things like errors in pages where sysindexes resides among many others. They do not have a good backup. I have had First Advantage Data Recovery Services (www.datarecovery.net) evaluate the database and quote to repair (over $7500).

Does anyone have any experience or reccomendations they can share about this or other companies that provide data recovery services for SQL databases?

View 5 Replies View Related

Msdb Maintain?!

Nov 15, 2006

hi expertsss..
my msdb database is like 2gb big.. to me is really big.. so is there a way to maintain that? and how. ..
also.. my disk level fragment are bad on one of my drive (some datafiles in there and msdb is there too). is there any 3rd party tool i can use to do the defragment and set schedule ? please help thanks~

View 7 Replies View Related

Transact SQL :: Change Db In Recovery To No-recovery And Restore Transaction Log?

May 5, 2015

in the process of migrating a big db from server 1 to server 2, we had to roll back the change. I started with taking a full db backup and restoring it on server 2 with norecovery, and then a couple logs with norecovery, and then the last log with recovery.

Is there some way to continue this chain now, I mean to change the db to norecovery, or other way to restore logs. 

I dont want to do a new full backup.

If I try to do a log restore now i get the message:

Msg 3117, Level 16, State 4, Line 1

The log or differential backup cannot be restored because no files are ready to rollforward.

Msg 3013, Level 16, State 1, Line 1

RESTORE LOG is terminating abnormally.

View 6 Replies View Related

Recovery :: AG Databases Went Into Synchronizing / In Recovery After Upgrading To 2014

Sep 19, 2015

We have 3 replica AG setup. 2 replicas are in sync/automatic failover, the other(DR Server, different subnet) in asynchronous/manual mode…All these replicas were on sql server 2012, Recently we upgraded DR server to 2014. Since then we have a problem, the AG databases in 2014 instance went into ‘Synchronizing/ in recovery’ state…The SQL server error log has message, the recovery couldn’t start for the database ‘XYZ’…We tried to create a new database and add it to AG , it works for fine for other two 2012 replicas, but on 2014 we see the same issue

View 3 Replies View Related

Recovery Of Dropped Data That Was Never Back Up

Nov 3, 2006

Hi

I am trying to recover a set of tables with data that was dropped. This data was not backed up. Please advice, is there any way this data can be recovered.

View 1 Replies View Related

How To Maintain Transaction Between Two Databases?

Apr 9, 2007

Hi All,
Pandon me for asking such question, I am still a beginner to ASP.NET.
I have a project that require me to do single operation that is suppose to update two databases, wonder how do I maintain transaction between these two databases? Please advise, thank you!

View 3 Replies View Related

How To Maintain Database Concurrence?

Apr 17, 2004

My application uses sql for performing operation. something like conncetion.execute(query). so there is only conncetion object no recordset object or something like that .

i want to run multiple instence of my application so i want to maintain integrety of data. and i am looking for solution through sql for locking mechanism. so concurrent data access dont currept data.

I hope you have uderstand my requirement.

View 1 Replies View Related

Data Recovery From SQL Server 2005 Mdf File.

Apr 1, 2008

Hello,
        Any body helop me in such respect that my log file was corrupt. I have mdf file only. Is there any tool to recover data from mdf file or export data to any other db.
 
thanks
Mansoor .net developer 
 
 

View 4 Replies View Related

Recovery :: Replication With Change Data Capture

Jul 14, 2015

SQL Server 2008R2: Enabling Change Data Capture on a replicated database or its tables will have any performance impact on existing transactional replication.Is it possible to use both of them con temporarily.

View 5 Replies View Related

Recovery :: How To Backup Raw Data Only With Just Views And Tables

Sep 23, 2015

My client has on a physical server (A), the following:

1. MS SQL Server 2008R2
2. MS SQL Server (Reporting Server)

The data base is backed up fully daily to another physical server (B).

What the client would like to do is:

1. Backup just the Raw SQL Data with Tables and Views to Server B every 10 mins

Point to be noted is, there isn't any dedicated storage (NAS or SAN) just local disk storage on the server.

The reason for this is they want to run reports against this data every 10-15 mins...

How and what do I need to do to facilitate this?

View 15 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved