May 4, 2003 at 9:27 pm
Hi everyone,
I am running an Active/Passive Replication. The Passive is basically serving as a Reporting database. Once the data replicated to the Passive server, it will then perform some jobs to calculate the reports.
The Production Server is the Publisher, the Reporting Server is the Distributor and Suscriber.
I am getting alot of errors while replication the data. The error would be "The agent is suspect. No responce withint last 1 minutes".
Do you think this is a lock for table when replication is trying to write into it?
May 5, 2003 at 4:01 am
I would most likely suspect just that. You might try setting the locking to page level specifically or use NOLOCK in your Report query to see if affects. However, the only way to know for sure is stop the process that handles the reporting. If you are going to run in this method you should consider a third sever for data to be imported to and use Analysis Services.
Edited by - antares686 on 05/05/2003 04:01:20 AM
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply