代码之家 › 专栏 › 技术社区 › Paw Baltzersen

缺少MS SQL Server 2008 R2复制插入日志文件

replication sql-server-2008

0

Paw Baltzersen · 技术社区 · 13 年前

我正在尝试在我的工作电脑和服务器这两台计算机之间设置一些复制。我已经在我的工作电脑上与另一个实例上的订阅者一起测试了发布者,它也在我的个人电脑上运行良好。我已经在我的工作电脑上创建了发布者,现在我正在服务器上创建订阅服务器。当代理启动时,我会得到以下日志:

2012-09-06 07:26:29.362 The process could not read file 'C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\ReplData\unc\LGX-PAW_REPTEST_REPTESTPUB\20120906085935\InsertLog_4.pre' due to OS error 3.
2012-09-06 07:26:29.377 Category:OS
Source:  
Number:  3
Message: The system cannot find the path specified.

我已经检查了路径,但它不存在,所以这个错误是有道理的,ReplData文件夹丢失了。现在的问题是,为什么这个文件夹不见了?

完整日志:

Date        06-09-2012 09:26:27
Log     Job History (LGX-PAW-RepTest-RepTestPub-PLX_SWDEV01\REPL2-DestinationDB-9A7A263C-E427-447C-982E-BC2FAD174935)

Step ID     1
Server      PLX_SWDEV01\REPL2
Job Name        LGX-PAW-RepTest-RepTestPub-PLX_SWDEV01\REPL2-DestinationDB-9A7A263C-E427-447C-982E-BC2FAD174935
Step Name       Run agent.
Duration        00:00:02
Sql Severity        0
Sql Message ID      0
Operator Emailed        
Operator Net sent       
Operator Paged      
Retries Attempted       0

Message
2012-09-06 07:26:27.770 Copyright (c) 2008 Microsoft Corporation
2012-09-06 07:26:27.770 Microsoft SQL Server Replication Agent: distrib
2012-09-06 07:26:27.770 
2012-09-06 07:26:27.770 The timestamps prepended to the output lines are expressed in terms of UTC time.
2012-09-06 07:26:27.770 User-specified agent parameter values:
            -Publisher LGX-PAW
            -PublisherDB RepTest
            -Publication RepTestPub
            -Distributor LGX-PAW
            -SubscriptionType 1
            -Subscriber PLX_SWDEV01\REPL2
            -SubscriberSecurityMode 1
            -SubscriberDB DestinationDB
            -Continuous
            -XJOBID 0x668947F23F047547879065B816A17E32
            -XJOBNAME LGX-PAW-RepTest-RepTestPub-PLX_SWDEV01\REPL2-DestinationDB-9A7A263C-E427-447C-982E-BC2FAD174935
            -XSTEPID 1
            -XSUBSYSTEM Distribution
            -XSERVER PLX_SWDEV01\REPL2
            -XCMDLINE 0
            -XCancelEventHandle 00000000000006C4
            -XParentProcessHandle 00000000000006B0
2012-09-06 07:26:27.770 Startup Delay: 1154 (msecs)
2012-09-06 07:26:28.925 Connecting to Subscriber 'PLX_SWDEV01\REPL2'
2012-09-06 07:26:28.940 Connecting to Distributor 'LGX-PAW'
2012-09-06 07:26:28.972 Parameter values obtained from agent profile:
            -bcpbatchsize 2147473647
            -commitbatchsize 100
            -commitbatchthreshold 1000
            -historyverboselevel 1
            -keepalivemessageinterval 300
            -logintimeout 15
            -maxbcpthreads 1
            -maxdeliveredtransactions 0
            -pollinginterval 5000
            -querytimeout 1800
            -skiperrors 
            -transactionsperhistory 100
2012-09-06 07:26:29.221 Initializing
2012-09-06 07:26:29.362 The process could not read file 'C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\ReplData\unc\LGX-PAW_REPTEST_REPTESTPUB\20120906085935\InsertLog_4.pre' due to OS error 3.
2012-09-06 07:26:29.377 Category:OS
Source:  
Number:  3
Message: The system cannot find the path specified.

1 回复 | 直到 13 年前

1

0

Paw Baltzersen 13 年前

发现有问题的目录需要位于订阅者可以访问的共享驱动器上。