January 23, 2014 at 8:18 am
Hi Team ,
Today morning somboday has removed our transcation replication from server . So I need to check who has deleted my replication and where i have check .
So please provide any command to check .
Regarding
Vivek
January 23, 2014 at 1:28 pm
unfortunately, i think you are pretty much out of luck on this. If you know the time when it was removed, you may be able to go through the Security event log to see who was logged in at the time, but that is not much of a smoking gun.
January 23, 2014 at 1:43 pm
If the default trace is enabled then you can get some information out of it.
January 24, 2014 at 3:11 am
Replication is data driven so unless you have some auditing you wont have much in the default trace but you may find something.
Is replication still enabled but the publications gone? Have the subscriptions also gone on the subscribers? Has the published db been restored without KEEP REPLICATION?
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply