Snapshot Agent Error -
11-01-2004
, 09:45 AM
Running Win 2k & SQL 2k.
My snapshot agents are scheduled to run in the AM on Sundays. Every Monday
when I check the replication monitor, there is an error on one if not more of
the agents stating..
Error:
The process could not create file
'd:\SQLData\MSSQL\ReplData\unc\SERVER_DataBase_Pub lication\20041031000029\Publication_1.sch'.
Full Massage:
The process cannot access the file because it is being used by another
process.
IF I start the agentent manually, it works fine. What could be using this
file when the agent attempts to run. Is having all my agents running at the
same time a problem? Should I stagger their starting?
TIA,
Larry... |