April 29, 2005 at 10:37 am
Hi,
I have a question in transactional replication.How do you check the synchronization between publisher and subscriber in transactional replication?
And also what is the maximum size of the database on which we can do transactional replication.
Any help is appreciated.
Thanks,
Sree
Thanks,
SR
May 2, 2005 at 8:00 am
This was removed by the editor as SPAM
May 4, 2005 at 12:22 pm
Hi Sree,
You can check jobs history in your Publisher server. Using your Enterprise Manager go to Management -> Jobs and check jobs with REPL in Category column. Also check Agents history in your Replication Monitor->Agents->Log Reader Agents and Distribution Agents for any failure.
Also, if you have any test table you could input some data into it, and check after few second on your subscriber to see if those data are replicated.
Size of database doesn’t matter; we are replicating 35 GB without problem. It depends however, on the current load and your server performance.
Regards,
Igor
May 4, 2005 at 8:39 pm
Thanks for your response Igor.I appreciate your help.
Sree
Thanks,
SR
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply