Azure数据同步TempDB错误 [英] Azure Data Sync TempDB Error
问题描述
我有一个表刚刚添加到我的同步组中，该表中有超过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.
请有人帮忙.
致谢
安德鲁
推荐答案
Hello,
Please verify your local SQL Server instance is not running out of space when the sync is running.
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,
Alberto Morillo
SQLCoffee.com
这篇关于Azure数据同步TempDB错误的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
