We have two servers running SQL Server 2008 Standard. I am using merge replication to replicate the entire database (11 GB, 350 tables) from Server 1 to Server 2 (pull subscriptions).
I have all the tables split up in about 10 publications.
I need about half of the database to be continuously updated every second, however, when I view the details of some of the tables in Replication Monitor I see a Download/Upload Progress bar that never gets to 100% and has an approximate time that keeps increasing.
I assume I/O is the bottleneck, so to test this theory I wanted to setup subscriptions on a new server we’ll be using for another project – which has a PCIe SSD (running SQL Server 2008 R2).
When I view the synchronization status on the subscriber (new server), I get the message:
“Skipping file TableName.sch' because it has already been delivered for a previous article or by a previously interrupted snapshot.”
In Replication Monitor, the status is Running and the message in the Error Message column changes the table name (and script applied) in the message “Bulk copying data into table ‘DifferentTableName’”.
But the table names and scripts keep repeating themselves.
In the Error Messages field at the bottom of the window, I get:
“The process was successfully stopped. (Sou
View Complete Post