MSRepl_command table growing - cleanup job failing

 

i have separate distribution server - sql 2005.

 

my distribution cleanup job failing following error:

executed user: <user>. not remove directory '\\<server>\repldata_bk\unc\lngokcsqlp003_bankruptcy_bk-smaller tables a-c\20071203122870\'. check security context of xp_cmdshell , close other processes may accessing directory. [sqlstate 42000] (error 20015).  step failed.

 

however error in agent log says this:

replication-@rowcount_only parameter must value 0,1, or 2. 0=7.0 compatible checksum. 1=only check rowcou: agent distribution@rowcount_only parameter must value 0,1, or 2. 0=7.0 compatible checksum. 1=only  scheduled retry. not clean distribution transaction tables.

 

when log in agent service account (also account job running under) , exec following:

exec xp_cmdshell 'dir d:\'

there no problem.

 

i saw 1 other thread marked "answered" on here same issue, no answers.

 

can help?

 

thanks,

deb

try giving sql server account rights snapshot folder.

 

from bol:

if publication dropped, replication attempts remove snapshot folder under security context of sql server service account. if account not have sufficient privileges, log in account have sufficient privileges , remove folder manually. removing folder requires modify privilege if folder local path or full control privilege if folder network path.

 

this worked me.

 

amy

 

SQL Server  >  SQL Server Replication