January 23, 2012 at 5:08 pm
I have a snapshot replication configured from Server A to B. There are about 200 articles in the publication and it runs once nightly. This server also has few other transcriptional replications configured. Distribution clean up and other jobs run successfully too but old snapshots are not getting deleted on daily basis. Can anyone please suggest me what could be going wrong here? Thanks in advance...
January 24, 2012 at 8:19 am
One more thing to mention - Allow Pull Subscription in Subscription option is set to true. Is this the issue because distribution agent runs at subscriber? Anyone?
January 26, 2012 at 10:24 am
I have heard lots of issues like this. 90% of the time, it is the permission issue. The agent job that runs it does not have rights to delete files and folders
When this happens, usually what is done is to make sure that the rights are good and then delete the old ones manually and keep an eye on it.
Just my 2 cents
-Roy
January 26, 2012 at 10:45 am
Thanks Roy. The account this job runs under has sufficient permissions. Because there are few other transactional replications too on this server and the same distribution clean up job is deleting all those other folders properly. Also, directory for this particular snapshot replication snapshots also have full control by that user. Do you suggest any specific permissions to check? if yes then where and what?
January 26, 2012 at 11:08 am
Here is something that you have to keep in mind. If on the first attempt to clean up the old directory fails due to some reason like file being locked up or some other silly reason, it will ignore those directories for the upcoming runs on wards. (I read this somewhere but cant find the link to it)
-Roy
January 26, 2012 at 11:16 am
That may be possible. I think I'll need to reinitialize my subscription all over again then. And see if that starts deleteing...
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply