SQL 2005事务复制问题? RRS feed

  • 问题

  • 运行环境:Windows 2003 Server SP2 (企业版), SQL Server 2005 sp3 (企业版)
    Command attempted:
    if @@trancount > 0 rollback tran
    (Transaction sequence number: 0x00033C8D00000010001300000000, Command ID: 3)

    Error messages:
    The Database ID 5, Page (1:29848), slot 0 for LOB data type node does not exist. This is usually caused by transactions that can read uncommitted data on a data page. Run DBCC CHECKTABLE. (Source: MSSQLServer, Error number: 7105)

    根据上面提到的 Transaction sequence number, 已找到出问题的表,在订阅方删除此表后,在发布方重新生成此表的快照后恢复正常。 上面类似问题出现过3次,但每次出问题的表并不相同。
    现在不确定是否是事务问题造成此原因, 请各位帮忙解决下,谢谢!

    2009年12月24日 5:14


  • Those processes will change point of blob data on source table, and cause table out of sync with subscriber because they are not replicated. When you update the table on blob data later, sql may unable to find same point on subscriber when the transaction replicated.
    2009年12月25日 18:05