Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

We had a log file that wouldn't stop growing even though we do backups. Turns out that replication had been turned on for that database. None of us DBAs did that (at least as far as we know). So, two questions.

  1. Can you tell after the fact who or what turned on replication. (We noticed that when we turned off replication there were no entries in the log.)
  2. What operations can turn on replication WITHOUT the executioner (there's a better word for that) of the operation to know that they are turning on replication.

Thanks in advance. We have fixed the problem but want to make sure it doesn't repeat itself.

share|improve this question

migrated from Mar 19 '14 at 19:20

This question came from our site for professional and enthusiast programmers.

Which version of SQL Server is this? – swasheck Mar 19 '14 at 19:19
We are running 2008 R2 – user3083310 Mar 19 '14 at 20:54

As for question 1, I don't think there's any way to know who enabled replication once you've torn it down. Even if it was still up, it'd be difficult (there is a login_name column in syssubscriptions that you might be able to use, for instance).

Speaking to point the second, the documentation for sp_addpublication says you need either sysadmin or db_owner to enable replication.

share|improve this answer
Perhaps maybe ... maybe ... they'd be the owner of the replication jobs too? – swasheck Mar 19 '14 at 21:05
If my environment is any indication, no. All of mine are owned by distributor_admin. Besides, a lot of times, tearing down replication will remove the jobs as well. – Ben Thul Mar 20 '14 at 1:55
That's right. It's been a while since I've worked with replication. Thanks for the information. – swasheck Mar 20 '14 at 3:43

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.