Monday, March 12, 2012

Replication and backups

Hi All,
Recently one of our servers went down and I need to restore a database
from backup. This database was the main publisher and distributor for a
two server replication scheme. My question is if I restore the main
publisher's table from a backup need I do anything to the subscriber?
Will I have to restore the subscriber from the backup as well? Thanks
for any help with this!
Regards,
Troy
the distribution database contains the commands which should be applied on
the subscriber to keep it synchronized with the publisher. There is a
tracking column on the distributor which is compared with the same tracking
column on the subscriber. The distribution agent compares the value of this
column to determine what commands to apply on the subscriber.
If you restore an earlier version of the distribution database to the
subscriber and the commands are still in the distribution database
everything will be fine. If they have been removed you will have to
re-initialize your subscriber.
"Troy" <poster[no-spam]@.designguide.com> wrote in message
news:MPG.1b0469879be23858989687@.msnews.microsoft.c om...
> Hi All,
> Recently one of our servers went down and I need to restore a database
> from backup. This database was the main publisher and distributor for a
> two server replication scheme. My question is if I restore the main
> publisher's table from a backup need I do anything to the subscriber?
> Will I have to restore the subscriber from the backup as well? Thanks
> for any help with this!
> --
> Regards,
> Troy

No comments:

Post a Comment