Running Win2k & SQL 2K
This AM when I checked my SQL servers, I had a red 'X' on
the snapshot folder of my central server. When I
expanded it, there were no snapshot agents. I have 45 or
so publications on this server and know each one has a
snapshot agent.
HELP!!!!
How do I get them back?
TIA,
Larry..
check to see if you can find these jobs in the jobs folder. If you can't
these agents where never created. Something is very wrong.
If they are there, its a visibility problems. This problem is most likely
caused when you deploy the publication via a script and don't use unique
publication or snapshot agent names. your best bet is to drop all
publications and rebuild them. You could try to script them out and
carefully modify them so the publications have different names, and leave
the snapshot_agent and distribution_agent parameters blank.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
"larry" <anonymous@.discussions.microsoft.com> wrote in message
news:406b01c4aa1b$6a22f010$a601280a@.phx.gbl...
> Running Win2k & SQL 2K
> This AM when I checked my SQL servers, I had a red 'X' on
> the snapshot folder of my central server. When I
> expanded it, there were no snapshot agents. I have 45 or
> so publications on this server and know each one has a
> snapshot agent.
> HELP!!!!
> How do I get them back?
> TIA,
> Larry..
|||Hilary,
They are in the jobs folder. The snapshot agents also
are in the Publication folder for each publication. What
gives? Does it really matter that they do not appear in
the Snapshot folder? Dropping the publications and
recreatiing them is not an option. Any othere ideas?
Larry...
|||believe it or not, it really doesn't matter. You just don't have the
visibility when your snapshot agents fail, which isn't often.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
<anonymous@.discussions.microsoft.com> wrote in message
news:1e9a01c4aa38$941a0440$a501280a@.phx.gbl...
> Hilary,
> They are in the jobs folder. The snapshot agents also
> are in the Publication folder for each publication. What
> gives? Does it really matter that they do not appear in
> the Snapshot folder? Dropping the publications and
> recreatiing them is not an option. Any othere ideas?
> Larry...
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment