Home Forums SQL Server 2012 SQL 2012 - General Distribution clean up: distribution job failure RE: Distribution clean up: distribution job failure

  • February 7, 2018 at 6:42 am

    #1978853

    tt-615680 - Wednesday, February 7, 2018 6:20 AM

    Sue_H - Wednesday, February 7, 2018 6:03 AM

    tt-615680 - Wednesday, February 7, 2018 3:39 AM

    I get the same error message even after giving the sql server account a 'full access' permission on the folderswhere the snapshots files are located

    Make sure it's whatever is the real path as specified in the error message. Default snapshot folder is not the same as where the snapshot files are it's a subfolder.
    Check the working_directory value in the MSdistpublishers table in msdb

    Sue

    The working_directory value in the MSdistpublishers table is different than the error message does that mean I need to amend the location and why would it be different than what it was set to?

    The error message is typically caused by permissions. I have no idea what \\Directory is pointing to or what directory was in the error message, That series of errors is exactly what you get with the permissions issue. You'll need to figure it out by going through the sp_MSdistribution_cleanup stored procedure the job executes.
    Here is a blog post about the error - it basically says the same thing I posted in my first reply:
    Distribution Agent fails with “Could not remove directory†error

    Sue