dbTalk Databases Forums  

Snapshot Agent Error

microsoft.public.sqlserver.replication microsoft.public.sqlserver.replication


Discuss Snapshot Agent Error in the microsoft.public.sqlserver.replication forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Larry
 
Posts: n/a

Default 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...

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2013, Jelsoft Enterprises Ltd.