Re: 2005 Replication Mon Interface

Tech-Archive recommends: Fix windows errors by optimizing your registry



Translated, it will take you a while to figure out where they put
everything. :)

--
Mike
Mentor
Solid Quality Learning
http://www.solidqualitylearning.com


"Hilary Cotter" <hilary.cotter@xxxxxxxxx> wrote in message
news:OwvBUtMEGHA.344@xxxxxxxxxxxxxxxxxxxxxxx
> Connect to your Publisher in WorkBench, expand the Replication node,
> expand Local Publications, right click on your publication and select
> Launch Replication Monitor (I think you are already here). Expand the
> Replication Monitor Node, My Publishers node, and your Publisher node, and
> locate your publication. Click on it and then in the Right Hand pane,
> select Warnings and Agents tab. In the lower portion of the pane locate
> your snapshot agent and right click on it to start it or stop it.
>
> You can also access it through the SQL Server Agent node in SQL WorkBench
> for your SQL Server, and expand the Jobs folder. Right click on your Agent
> (if you can locate it by its name) and select Start Job or Stop Job.
>
> I think at this point it is important to point out that the Replication
> Wizards and interfaces were completely redesigned to make them more
> intuitive and less confusing.
>
> --
> 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
>
> "TCorp" <tcorpus@xxxxxxxxxxx> wrote in message
> news:OtxxSZMEGHA.2300@xxxxxxxxxxxxxxxxxxxxxxx
>>I am playing around with the new Replication Monitor in 2005. In the old
>>Replication Monitor (SQL Sever2k), you could right click on a subscription
>>and Start or Stop Synchronizing. So far I have not been able to find this
>>feature in the new Replication Monitor and I've had to SQL Server
>>Management Studio to be able to control the subscription. Our
>>subscriptions frequently go off-line (off-site) and sometimes require a
>>manual start when they return, so access to this feature for all
>>subscriptions in one place is handy.
>>
>> Thanks for any help.
>> Ted.
>>
>
>


.



Relevant Pages

  • Re: SQL Server 2005 replication monitor questions
    ... >> To get to the agents expand SQL Server Agent jobs, ... click on your publication in Enterprise ... >> bottom half you will see your snapshot and distribution agent. ... >> monitor it there (through replication monitor). ...
    (microsoft.public.sqlserver.replication)
  • Re: sp_replcmds
    ... It is possible that there is an open transaction ... Looking for a book on SQL Server replication? ... >> Stop SQL Server agent, restart it and see if this clears the error. ... Use Replication Monitor to view the details of> this ...
    (microsoft.public.sqlserver.replication)
  • Re: Application is closed during second synchronization
    ... To start the merge agent in SQL Server 2000, open Enterprise Manager, ... Replication Monitor, Expand the publication and on the RHS you'll see the ...
    (microsoft.public.sqlserver.replication)
  • Re: SQL Server 2005 replication monitor questions
    ... It seems to be the order that they were registered in Replication Monitor. ... To get to the agents expand SQL Server Agent jobs, ... click on your publication in Enterprise ... Looking for a SQL Server replication book? ...
    (microsoft.public.sqlserver.replication)
  • Re: Following error seen in Distribution agent history
    ... I'm wondering if the issue is a permissions one. ... you set the domain user that the pull agent runs as (sql server agent on ... subscriber) to be the same as that used on the publisher and this'll tell us ... BTW I'm assuming that the sql server ...
    (microsoft.public.sqlserver.replication)