Step 1 - I copied user tables (via a DTC local package) from Server 1 --> Server 3
Step 2. Tested some pgms on Server 1
Step 3. Copied user tables (via a DTC local package)
from Server 3 --> Server 1 to get restore the data
back to pre-test status.
All the while, replication (Server 1-->2) was active.
The Problem: Even though replication was active, the tables on Server 2 are empty, no rows. For some reason,
when I copied data back to Server 1, it did not get
replicated over to Server 2.
What is the best method to get these databases back in-sync?
(Server 2 is my alternate server which I need to use when can't run on Server 1)
(Replication is working now and reflects changes that
have occurred during today)
?? If I go into Agent Properties and uncheck the Enabled setting, is that all Inned to do to temporarily disable replication??
Then I was planning to run a DTC local package to copy all user tables from Server 1--> Server 2
Then re-enable the replication. All of this while system is not in-use by user jobs of course.
Will this plan work..... any better ideas ?
Thanks, John
Step 2. Tested some pgms on Server 1
Step 3. Copied user tables (via a DTC local package)
from Server 3 --> Server 1 to get restore the data
back to pre-test status.
All the while, replication (Server 1-->2) was active.
The Problem: Even though replication was active, the tables on Server 2 are empty, no rows. For some reason,
when I copied data back to Server 1, it did not get
replicated over to Server 2.
What is the best method to get these databases back in-sync?
(Server 2 is my alternate server which I need to use when can't run on Server 1)
(Replication is working now and reflects changes that
have occurred during today)
?? If I go into Agent Properties and uncheck the Enabled setting, is that all Inned to do to temporarily disable replication??
Then I was planning to run a DTC local package to copy all user tables from Server 1--> Server 2
Then re-enable the replication. All of this while system is not in-use by user jobs of course.
Will this plan work..... any better ideas ?
Thanks, John