Missing Snapshot agents

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

missing hd partition

hello, we have sqlserver2K on Win2K SP4 on two machines namely prod and
backup. on backup when i do EM backup and click on the "add" device i
could view the different hard disk partitions of my server (C:, D:, E:,
F. but on the prod i could only view C: even though there is a D:
partition. previously i had scheduled an EM backup to D: partition on
this prod server. last week i noticed that the backup is failing
because D: is not being "seen" by EM. i've read through the BOL but
couldn't find a clue (probably i'm thick) so i'm asking if anyone could
shed a light on how EM "see" the D: partition?maverick wrote:
> hello, we have sqlserver2K on Win2K SP4 on two machines namely prod and
> backup. on backup when i do EM backup and click on the "add" device i
> could view the different hard disk partitions of my server (C:, D:, E:,
> F. but on the prod i could only view C: even though there is a D:
> partition. previously i had scheduled an EM backup to D: partition on
> this prod server. last week i noticed that the backup is failing
> because D: is not being "seen" by EM. i've read through the BOL but
> couldn't find a clue (probably i'm thick) so i'm asking if anyone could
> shed a light on how EM "see" the D: partition?
>
Verify that the SQL Server service account (check the service
properties) has permissions to read/write on the "missing" partition.
Tracy McKibben
MCDBA
http://www.realsqlguy.com|||Tracy McKibben wrote:
> Verify that the SQL Server service account (check the service
> properties) has permissions to read/write on the "missing" partition.
>
> --
> Tracy McKibben
> MCDBA
> http://www.realsqlguy.com
that worked! the account that sqlserver is using doesn't have
permissions on the "missing" partition.
thank you so much Tracy for your help!

missing hd partition

hello, we have sqlserver2K on Win2K SP4 on two machines namely prod and
backup. on backup when i do EM backup and click on the "add" device i
could view the different hard disk partitions of my server (C:, D:, E:,
F:). but on the prod i could only view C: even though there is a D:
partition. previously i had scheduled an EM backup to D: partition on
this prod server. last week i noticed that the backup is failing
because D: is not being "seen" by EM. i've read through the BOL but
couldn't find a clue (probably i'm thick) so i'm asking if anyone could
shed a light on how EM "see" the D: partition?maverick wrote:
> hello, we have sqlserver2K on Win2K SP4 on two machines namely prod and
> backup. on backup when i do EM backup and click on the "add" device i
> could view the different hard disk partitions of my server (C:, D:, E:,
> F:). but on the prod i could only view C: even though there is a D:
> partition. previously i had scheduled an EM backup to D: partition on
> this prod server. last week i noticed that the backup is failing
> because D: is not being "seen" by EM. i've read through the BOL but
> couldn't find a clue (probably i'm thick) so i'm asking if anyone could
> shed a light on how EM "see" the D: partition?
>
Verify that the SQL Server service account (check the service
properties) has permissions to read/write on the "missing" partition.
Tracy McKibben
MCDBA
http://www.realsqlguy.com|||Tracy McKibben wrote:
> Verify that the SQL Server service account (check the service
> properties) has permissions to read/write on the "missing" partition.
>
> --
> Tracy McKibben
> MCDBA
> http://www.realsqlguy.com
that worked! the account that sqlserver is using doesn't have
permissions on the "missing" partition.
thank you so much Tracy for your help!