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.
Showing posts with label situationwe. Show all posts
Showing posts with label situationwe. Show all posts
Thursday, March 29, 2012
DATABASE MOVE
Labels:
2kthis,
database,
distributor,
microsoft,
mysql,
oracle,
replication,
server,
situationwe,
sql,
transactional
Subscribe to:
Posts (Atom)