Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations MikeeOK on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How to Stop Replication so can copy tables to the backup server

Status
Not open for further replies.

JohnBates

MIS
Feb 27, 2000
1,995
US
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


 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top