SQL 2K
This is my situation
We got a Transactional Replication set up between Server A and Server B.
Server A is the Distributor and B the Subscriber.
Recently we moved the database in Server A to another server , say Server C
and linked the Replication back to Server B
Before the move, one of my replicated table, say myTable got 2 records .
Now when I delete this 2 records , this deletion is not getting replicated
back to server B. All new changes (including INSERT/DELETE/UPDATE)
are getting replicated correctly..
Any thoughts/suggestions
ShamimTurn on logging of the Distribution agent and run profiler on both the
Publisher/Distributor and Subscriber.
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.
Thursday, March 29, 2012
DATABASE MOVE
Labels:
2kthis,
database,
distributor,
microsoft,
mysql,
oracle,
replication,
server,
situationwe,
sql,
transactional
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment