本文介绍了Azure数据同步TempDB错误的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!

问题描述

限时删除!!

我有一个表刚刚添加到我的同步组中,该表中有超过100万行.尝试同步时,我收到此错误消息,并且只有大约一半的行已同步.

I've got a table that I've just added to my sync group that has over a 1 million rows in it.  When it is trying to sync I am receiving this error message, and only about half the rows have synced across.

应用批处理文件C:\ Users \ CLIENT〜1 \ AppData \ Local \ Temp \ DSS2_925e04bb-2c4f-40c7-b93c-64ac2a905e52 \ sync_393a2f37809c465db72726633d969136fba610f91baa4a4cb964bfddf4df4df4df4df4df4df4dbdf4dfdfdf4dfdfdfdfdfdfdfdfdfdfdfdfdfdfdfdfdfdfd-dfd-dfd-dfd-dfd-df-dfd-dfd-dfd-dfd-dfd-dfd-dfd-dfd-dfd-dfd-dfd-dfd-dfd-dfd-dfd-dfd-dfd-dfd-df-df-df-dfdfdfdfdfdfdfdfdfdfdfdfdfdfc见 内部异常以获取更多详细信息.
内部异常:无法对表"dbo.TokenMarketing"执行命令"BulkInsertCommand";交易已回滚.确保命令语法正确.
内部异常:SqlException错误代码:-2146232060-SqlError编号:3958,消息:访问数据库'ClientPortal-Live'中的表'dbo.TokenMarketing'中的版本化行时,事务中止.找不到请求的版本化行.您的tempdb可能是 空间不足.请参考BOL,了解如何配置tempdb进行版本控制.
 有关详细信息,请向客户支持提供跟踪ID"925e04bb-2c4f-40c7-b93c-64ac2a905e52".

An unexpected error occurred when applying batch file C:\Users\CLIENT~1\AppData\Local\Temp\DSS2_925e04bb-2c4f-40c7-b93c-64ac2a905e52\sync_393a2f37809c465db72726633d969136fba610f91baa4a4cb964bfd355d147e6\42ba8abd-5216-4fdf-b14f-6b41fdacb532.batch. See the inner exception for more details.
Inner exception: Failed to execute the command 'BulkInsertCommand' for table 'dbo.TokenMarketing'; the transaction was rolled back. Ensure that the command syntax is correct.
Inner exception: SqlException Error Code: -2146232060 - SqlError Number:3958, Message: Transaction aborted when accessing versioned row in table 'dbo.TokenMarketing' in database 'ClientPortal-Live'. Requested versioned row was not found. Your tempdb is probably out of space. Please refer to BOL on how to configure tempdb for versioning.
 For more information, provide tracing ID ‘925e04bb-2c4f-40c7-b93c-64ac2a905e52’ to customer support.

请有人帮忙.

致谢

安德鲁

推荐答案

请确保同步运行时,您的本地SQL Server实例未耗尽空间.

Please verify your local SQL Server instance is not running out of space when the sync is running.

请将TempDB的大小设置为从5 GB开始.

Please set TempDB size to start at 5 GB.

https://logicalread.com/sql-server-tempdb-best-practices-initial-sizing-w01/#.XAfVN7mWzDc

https://logicalread.com/sql-server-tempdb-best-practices-initial-sizing-w01/#.XAfVN7mWzDc


希望这会有所帮助.


Hope this helps.


问候


Regards,

阿尔贝托·莫里洛
SQLCoffee.com

Alberto Morillo
SQLCoffee.com


这篇关于Azure数据同步TempDB错误的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!

1403页,肝出来的..

09-08 01:16