Some problem happen from Appliction side & it was brought to my
attention that i have to restore the production database & same
production Database is used for transactional replication. i am not
sure if i restore the database it will break the replication or what
is better way to RESTORE. any help is appreciated & thanking in
advance.
If you restore to an earlier version of the production database, that means
that potentially you'll have non-convergence with the subscribers. You could
then do a comparison with a subscriber and decide which records to upload
from the subscriber, although this could end up being really complicated.
After that, I'd reinitialize the subscriber.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
|||Thanks for your reply, that is what i thought. thanks for your help
again.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment