April 21, 2009 at 4:10 pm
Hi Experts,
I have a queston regarding synchronization of subscriber with publisher..................Basically , we have transactinal replication in our environments and these are quite heavy databases ( in terra bytes...so do the pulications).
Quite often we see that the subsciber rowcounts is not exactly same as the publisher rowcounts . These publicatino are quite big.
As publication are quite big, I cannot start the snapshot agent during the day and then let it go during business hours as per the policies here.
Experts,
Could you please post your reply in detail , how I can achieve this synchronization in best possible manner.
Configuration: SQL Server 2005 ( Publisher ,Distributor,Subsciber)
Thanks for your help.
January 14, 2010 at 10:29 pm
Hi,
I have similar question.
How do you sync a subscriber from a publisher backup?
I want to get a copy of the publisher backup several days back and restore to a different server.
Then I want to configure transactional replication to the database I just restore.
How do I setup replication from a database restore without violating primary key?
Any suggestion is greatly appreciated.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy