May 15, 2008 at 8:30 am
Hi
I have a Distribution clean up job failing on a SQL 2K5 Enterprise Instance (Windows Server 2003) Failing with the following error:-
Executed as user: *******. Could not remove directory 'DIRECTORY....'. Check the security context of xp_cmdshell and close other processes that may be accessing the directory. [SQLSTATE 42000] (Error 20015). The step failed.
I have checked all the obvious xp_cmdshell permissions, account permissions etc.
I can delete the folders when I log on to the server as admin.
When i look in to event viewer i find this error:-
Replication-@rowcount_only parameter must be the value 0,1, or 2. 0=7.0 compatible checksum. 1=only check rowcou: agent distribution@rowcount_only parameter must be the value 0,1, or 2. 0=7.0 compatible checksum. 1=only scheduled for retry. Could not clean up the distribution transaction tables.
Cheers,
Paul
May 15, 2008 at 10:18 am
You cannot remove a Directory in use, no matter what your privileges are. I wold suggest trying to find the directory that it is trying to remove and see what else is using it.
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
January 13, 2014 at 1:31 pm
I have the same issue.
my 'unc' folder automatically set security without fullcontrol for SQLSERVERAGENT when I setup the publictions. I had manully granted full control to SQLSERVERAGENT. (xp_cmdshell enabled. [NT SERVICE\SQLSERVERAGENT] in sysadmin role)
I didn't find other process is in use on those folders(expired snapshots). I can manully delete the unc's subforders.
appreciate any helps...
September 28, 2017 at 7:03 am
This was removed by the editor as SPAM
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply