Hi,
I use a transactional replication and sometimes I realize that all or
some tables at subscriber are empty but the agent history don't log any
error message. All the informations at the publisher is ok. This
morning, I looked to the data at 10AM and all was fine but an hour
after some tables was empty. The snapshot doesn't start and no one use
the subscriber's database.
Any ideas?
Patrick Simard
Patrick - do you have access to Log Explorer or similar tools? It might be
worht investigating the subscriber logs. Typically I've fond a developer
process responsible for this type of thing, or a cascade trigger which
shouldn't exist on the subscriber.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com .
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment