Data is not replicated, although all definitions looks OK.
Solution:
Can be more than one reason, try to check:
- Check definition of databases and servers – all those definitions can be very confusing… (names, IPs, etc. [sql.ini])
- Check PKs in both sides – as already mentioned above: primary and replicated
- Permissions issues
- RS permissions – example: grant role replication_role to sa (RSSD database)
- Primary DB
- Replicated DB – example: GRANT INSERT, UPDATE, DELETE ON replicated table to the maintanance user of RS (_maint)
- Network and connections issues – permissions to inbound/outbound access to/from the servers.
- don’t forget after fixing a problem to resume connection the server.database
- LTM is not set to the correct “locator” value.
- rs_zeroltm, dbcc settrunc(ltm, valid)
No comments:
Post a Comment