Replication Issue

Hi:
I need to detach and detach the publisher database in transactional
replication. To do that, I need to disable publication from this database
which will also remove all the publications for this database. I will script
all the publications before I disable.
After attaching the database and enabling publication, I run the script to
create the publication again. After I do this, this does not start the
replication. Snapshot agent and Logreader agent are sitting idle. The
snapshot agents only run on the weekend. Do I have to run snapshot agents
again to start replication which I want to avoid during business hours? How
about Logreader agent, is it waiting for snapshot agent to execute first?
Please let me know.
Thanks a lot
If the agents are idle it should mean replication is working. Run profiler
and then do some dummy updates like this
update TableName set col1=col1
Making sure col1 is not a pk column.
You should see stuff flow.
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
"Paul" <Paul@.discussions.microsoft.com> wrote in message
news:2B465355-B58F-4457-80D0-4457D5772C9F@.microsoft.com...
> Hi:
> I need to detach and detach the publisher database in transactional
> replication. To do that, I need to disable publication from this database
> which will also remove all the publications for this database. I will
> script
> all the publications before I disable.
> After attaching the database and enabling publication, I run the script to
> create the publication again. After I do this, this does not start the
> replication. Snapshot agent and Logreader agent are sitting idle. The
> snapshot agents only run on the weekend. Do I have to run snapshot agents
> again to start replication which I want to avoid during business hours?
> How
> about Logreader agent, is it waiting for snapshot agent to execute first?
> Please let me know.
> Thanks a lot
>
|||No. Replication is not working at this point becuase if you look at
subcription under publication folder it shows pending status. If I run
snapshot agent, it will then show active status and any transaction will
start applying. Is there anyway to activate the subscription without running
snapshot agents because I can't really do this during business hours?
"Hilary Cotter" wrote:

> If the agents are idle it should mean replication is working. Run profiler
> and then do some dummy updates like this
> update TableName set col1=col1
> Making sure col1 is not a pk column.
> You should see stuff flow.
> --
> 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
> "Paul" <Paul@.discussions.microsoft.com> wrote in message
> news:2B465355-B58F-4457-80D0-4457D5772C9F@.microsoft.com...
>
>