Re: Error in Distribution Clean Up Agent
- From: "Hilary Cotter" <hilary.cotter@xxxxxxxxx>
- Date: Tue, 21 Nov 2006 09:21:13 -0500
can you make sure xp_cmdshell is enabled? Do this:
exec master.dbo.sp_configure 'xp_cmdshell'
If run value is 0, do this
exec master.dbo.sp_configure 'xp_cmdshell',1
reconfigure with override
Then start up your distribution clean up task.
--
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"noda" <hend_g@xxxxxxxxxxx> wrote in message
news:1164102353.485024.276880@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
ÚäÏì
Server 1 SQL 2000 (SP4) Distributor, Publisher
Server 2 SQL 2000 (SP4) Subscriber
Transactional Replication set up between Server 1 and 2.
All the agents are running successfully (Log Reader, Snapshot, Other
Miscellenaous agent...except the Distribution Clean Up Agent
ÊÚØì åÐÇ error
Executed as user: COOP\sqladmin. Could not remove directory
'\\ALXCONTGC\ReplData\unc\ALXCONTGC_sales_Pub_Alxoffc_Anualtrans\20061119100406\'.
Check the security context of xp_cmdshell and close other processes
that may be accessing the directory. [SQLSTATE 42000] (Error 20015)
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. [SQLSTATE 01000] (Message 14152).
The step failed.
åá ÇÍÏ ÚäÏå Íá áåÐå ÇáãÔßáÉ¿
.
- References:
- Error in Distribution Clean Up Agent
- From: noda
- Error in Distribution Clean Up Agent
- Prev by Date: Complicated Merge Replication/Trigger problem
- Next by Date: Re: Merge replication schema changes
- Previous by thread: Error in Distribution Clean Up Agent
- Next by thread: Re: Error in Distribution Clean Up Agent
- Index(es):
Relevant Pages
|
Loading
