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.
The button you are looking for is called "Start Synchronizing" with the
corrollary of "Stop Synchronizing". I can't remember exactly where it is,
but it is located somewhere around the actual subscription.
Mike
Mentor
Solid Quality Learning
http://www.solidqualitylearning.com
"TCorp" <tcorpus@.hotmail.com> wrote in message
news:OtxxSZMEGHA.2300@.TK2MSFTNGP15.phx.gbl...
>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.
>
|||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@.hotmail.com> wrote in message
news:OtxxSZMEGHA.2300@.TK2MSFTNGP15.phx.gbl...
>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.
>
|||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@.gmail.com> wrote in message
news:OwvBUtMEGHA.344@.TK2MSFTNGP11.phx.gbl...
> 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@.hotmail.com> wrote in message
> news:OtxxSZMEGHA.2300@.TK2MSFTNGP15.phx.gbl...
>
|||This article should help clarify things a bit:
http://www.replicationanswers.com/GUIArticle.asp
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
|||Thanks everyone for your help and prompt replies.
But what I am looking for is to stop and start my (pull) Merge Agents.
Looking at Paul Ibison's helpful article, I realize that the option to Start
and Stop the merge agents is not there (in the All Subscriptions Tab of my
publication). The only options when I right-click the subscription are:
- View Details
- Reinitialize Subscription
- Validate Subscription
- Agent Profile
- Properties
- Refresh
Currently, the only way I can Start/Stop the merge agents is to connect to
the [subscription] server in Management Studio, open the
"Replication-->Local Subscriptions" folder, right-click the subscription and
select "View Synchronization Status". That dialog box give me buttons to
Start and Stop the agent.
Strangely, I thought I created a publication last week (in my testing) that
had that option there, and that's part of the reason I am so confused right
now, as it seems to have disappeared.
My publisher/distributor is SQL Server 2005 and my pull merge subscriptions
are running on MSDE.
Thanks again.
------
"TCorp" <tcorpus@.hotmail.com> wrote in message
news:OtxxSZMEGHA.2300@.TK2MSFTNGP15.phx.gbl...
>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.
>
|||Now that I know where the option to synchronize really was (Thanks Paul) and
that it was missing, I was able to look further into it.
It seems that it is a difference between push and pull merge agents. The
option to Start/Stop synchronizing the Merge agents seems to only be
available for PUSH subscriptions in the Replication monitor. These articles
implicate such:
http://msdn2.microsoft.com/en-us/library/ms152749.aspx
http://msdn2.microsoft.com/en-us/library/ms151261.aspx
We've historically used Pull subscriptions because our MSDE subscribers were
often off-line and we were experiencing a lot of error messages in the
replication monitor. But now I must reconsider using push again.
My only recourse now to to ask if anyone knows why the 2005 Replication
Monitor does not allow us to Start/Stop pull subscriptions.
Thanks, Ted.
"TCorp" <tcorpus@.hotmail.com> wrote in message
news:OxOc%23ZVEGHA.1120@.TK2MSFTNGP11.phx.gbl...
> Thanks everyone for your help and prompt replies.
> But what I am looking for is to stop and start my (pull) Merge Agents.
> Looking at Paul Ibison's helpful article, I realize that the option to
> Start and Stop the merge agents is not there (in the All Subscriptions Tab
> of my publication). The only options when I right-click the subscription
> are:
> - View Details
> - Reinitialize Subscription
> - Validate Subscription
> - Agent Profile
> - Properties
> - Refresh
> Currently, the only way I can Start/Stop the merge agents is to connect to
> the [subscription] server in Management Studio, open the
> "Replication-->Local Subscriptions" folder, right-click the subscription
> and select "View Synchronization Status". That dialog box give me buttons
> to Start and Stop the agent.
> Strangely, I thought I created a publication last week (in my testing)
> that had that option there, and that's part of the reason I am so confused
> right now, as it seems to have disappeared.
> My publisher/distributor is SQL Server 2005 and my pull merge
> subscriptions are running on MSDE.
> Thanks again.
> ------
> "TCorp" <tcorpus@.hotmail.com> wrote in message
> news:OtxxSZMEGHA.2300@.TK2MSFTNGP15.phx.gbl...
>
Sunday, February 19, 2012
2005 Replication Mon Interface
Labels:
click,
database,
interface,
microsoft,
mon,
monitor,
mysql,
oldreplication,
oracle,
playing,
replication,
server,
sever2k,
sql,
subscriptionand
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment