Hi All,
My replication process working well , meaning it replicates the
data properly but it is not reflected in my 'Replication Monitor' , it always
shows failure (Red shadow on the 'Publishers' and 'Agents-->Distribution
Agents' .Note that the subsriber using 'push' method to get the data ,
distribution data base sitting on Publisher's server.We delete and re-create
the whole thong again but not useful.Any idea?...
The replication monitor gets its info from
tempdb.dbo.MSreplication_agent_status and running
sp_MSload_replication_status refreshes this table. As restarting the SQL
Server Service causes the tempdb to be recreated from the model database,
this should also remove the problem.
Rgds,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
sql
Showing posts with label monitor. Show all posts
Showing posts with label monitor. Show all posts
Wednesday, March 28, 2012
Wednesday, March 7, 2012
Replication Montor 2005
Is there any way to configure repl. monitor in 2005 to view all the publications that go
via a distributor in one place? (as opposed to having to link to each publisher to see the replictaion status).
we have 7 publishers going throigh one distributor and in 2000 could see them all on the distributor...now have to connect to each publisher & look on each...
Thanks
DesX
This is a design change in SQL 2005 (largely based on customer feedback), and there's no way to accomplish what you want with the given tools.
However if you want to build your own tool, you can. SQL Monitor is built around proc sp_replmonitorpublication, which has parameter @.publisher. If NULL, you get everything back for the given distributor.
Replication Monitoring
SQL Server 2000 EE.
What is the best way to monitor replication and have it send an email to me
as soon as it fails for some reason ? Is there a 3rd party utility for better
monitoring ?
Thanks.
You can utilize internal sql mail (if you have it configured). When
you setup your publications and subscriptions sql2000 will generate
jobs. In jobs properties you can set it to send you an e-mail if it
fails.
You can also write custom jobs to do this for you:
http://msdn2.microsoft.com/en-us/library/ms147874.aspx
T.
DXC wrote:
> SQL Server 2000 EE.
> What is the best way to monitor replication and have it send an email to me
> as soon as it fails for some reason ? Is there a 3rd party utility for better
> monitoring ?
> Thanks.
|||There are some built-in alerts for replication monitoring. In particular
there is the "Replication: agent failure" alert - you could enable this and
on the response tab select an operator to notify. For a more granular
approach you could identify the replication jobs themselves and define
operators to send emails to if the job fails.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com .
What is the best way to monitor replication and have it send an email to me
as soon as it fails for some reason ? Is there a 3rd party utility for better
monitoring ?
Thanks.
You can utilize internal sql mail (if you have it configured). When
you setup your publications and subscriptions sql2000 will generate
jobs. In jobs properties you can set it to send you an e-mail if it
fails.
You can also write custom jobs to do this for you:
http://msdn2.microsoft.com/en-us/library/ms147874.aspx
T.
DXC wrote:
> SQL Server 2000 EE.
> What is the best way to monitor replication and have it send an email to me
> as soon as it fails for some reason ? Is there a 3rd party utility for better
> monitoring ?
> Thanks.
|||There are some built-in alerts for replication monitoring. In particular
there is the "Replication: agent failure" alert - you could enable this and
on the response tab select an operator to notify. For a more granular
approach you could identify the replication jobs themselves and define
operators to send emails to if the job fails.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com .
Replication Monitoring
SQL Server 2000 EE.
What is the best way to monitor replication and have it send an email to me
as soon as it fails for some reason ? Is there a 3rd party utility for bette
r
monitoring ?
Thanks.You can utilize internal sql mail (if you have it configured). When
you setup your publications and subscriptions sql2000 will generate
jobs. In jobs properties you can set it to send you an e-mail if it
fails.
You can also write custom jobs to do this for you:
http://msdn2.microsoft.com/en-us/library/ms147874.aspx
T.
DXC wrote:
> SQL Server 2000 EE.
> What is the best way to monitor replication and have it send an email to m
e
> as soon as it fails for some reason ? Is there a 3rd party utility for bet
ter
> monitoring ?
> Thanks.|||There are some built-in alerts for replication monitoring. In particular
there is the "Replication: agent failure" alert - you could enable this and
on the response tab select an operator to notify. For a more granular
approach you could identify the replication jobs themselves and define
operators to send emails to if the job fails.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com .
What is the best way to monitor replication and have it send an email to me
as soon as it fails for some reason ? Is there a 3rd party utility for bette
r
monitoring ?
Thanks.You can utilize internal sql mail (if you have it configured). When
you setup your publications and subscriptions sql2000 will generate
jobs. In jobs properties you can set it to send you an e-mail if it
fails.
You can also write custom jobs to do this for you:
http://msdn2.microsoft.com/en-us/library/ms147874.aspx
T.
DXC wrote:
> SQL Server 2000 EE.
> What is the best way to monitor replication and have it send an email to m
e
> as soon as it fails for some reason ? Is there a 3rd party utility for bet
ter
> monitoring ?
> Thanks.|||There are some built-in alerts for replication monitoring. In particular
there is the "Replication: agent failure" alert - you could enable this and
on the response tab select an operator to notify. For a more granular
approach you could identify the replication jobs themselves and define
operators to send emails to if the job fails.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com .
Replication Monitor Times and Handheld Synchronization times
Hello
When i am Synchronizing(SQL2005 merge replication)
I can see the duration of the Synchronization on the Replication
monitor and i can see that lets say an "initial loading" of the
database with lots of data is taking 4 minutes but on the handheld if i
take the time of the Synchronize() command that can take up to 30
minutes.
Why is this happening? Am I doing something wrong here?
Thanks
Savvas Christodoulou
The replication monitor shows the time it took for the server side
reconciler to write the initial data to the .OUT file in the IIS server.
The writing of the OUT file to the device can take longer depending on your
network connection etc.
<savvaschr@.nodalsoft.com.cy> wrote in message
news:1162307433.787568.183190@.e3g2000cwe.googlegro ups.com...
> Hello
> When i am Synchronizing(SQL2005 merge replication)
> I can see the duration of the Synchronization on the Replication
> monitor and i can see that lets say an "initial loading" of the
> database with lots of data is taking 4 minutes but on the handheld if i
> take the time of the Synchronize() command that can take up to 30
> minutes.
> Why is this happening? Am I doing something wrong here?
> Thanks
> Savvas Christodoulou
>
|||Thanks a lot ,
I finaly understood what was going on just after i post this message.
Regards
When i am Synchronizing(SQL2005 merge replication)
I can see the duration of the Synchronization on the Replication
monitor and i can see that lets say an "initial loading" of the
database with lots of data is taking 4 minutes but on the handheld if i
take the time of the Synchronize() command that can take up to 30
minutes.
Why is this happening? Am I doing something wrong here?
Thanks
Savvas Christodoulou
The replication monitor shows the time it took for the server side
reconciler to write the initial data to the .OUT file in the IIS server.
The writing of the OUT file to the device can take longer depending on your
network connection etc.
<savvaschr@.nodalsoft.com.cy> wrote in message
news:1162307433.787568.183190@.e3g2000cwe.googlegro ups.com...
> Hello
> When i am Synchronizing(SQL2005 merge replication)
> I can see the duration of the Synchronization on the Replication
> monitor and i can see that lets say an "initial loading" of the
> database with lots of data is taking 4 minutes but on the handheld if i
> take the time of the Synchronize() command that can take up to 30
> minutes.
> Why is this happening? Am I doing something wrong here?
> Thanks
> Savvas Christodoulou
>
|||Thanks a lot ,
I finaly understood what was going on just after i post this message.
Regards
Replication Monitor SqlServerCE
I have developed a smart device application using SqlServerCE that replicates data to the backend server. I need to provide to the user a status of this replication process. I read about the "MergeSubscriberMonitor" in SQL Server but can't find it in SqlServerCe. Is this possible? Can someone please point me in the right direction?You need to wait for synchronisation to finish and then you can query to MergeReplication object to report on the data transferred.
If you were using SQLMobile (the CE version for SQL 2005), there is messaging available that will give you progress updates.|||I'm not sure I understand what your comment "messaging" is referring to. Do you have or can point me to some sample code that uses messaging? I am using SQL CE on the mobile device.|||Sorry, by messaging I mean events that you can catch within code and then react to. With SQL CE I don't believe this is happening. You can only query the replication object at the completion of the synchronisation process in order to determine what the outcome was (data sent and received)|||Thanks for your response. I did try asynchronous replication and it is working well so far. I need to implement some additional error trapping but I think I have 95% of what I need. It allows me to get a "percent of completion" during the sync process. I can then display this on the screen to my users. The database is VERY large and was taking forever to sync. I really needed some type of progress bar to show the user. Without that status update, it appeared the unit was locked up. Thanks anyway for your reponse.|||Hi,
I am also trying to get a status update on each article during the web synchronization process. Can you please update me on how to monitor the percent complete progress for the replication.
Thanks in advance.
Apurva
Replication Monitor SqlServerCE
I have developed a smart device application using SqlServerCE that replicates data to the backend server. I need to provide to the user a status of this replication process. I read about the "MergeSubscriberMonitor" in SQL Server but can't find it in SqlServerCe. Is this possible? Can someone please point me in the right direction?You need to wait for synchronisation to finish and then you can query to MergeReplication object to report on the data transferred.
If you were using SQLMobile (the CE version for SQL 2005), there is messaging available that will give you progress updates.|||I'm not sure I understand what your comment "messaging" is referring to. Do you have or can point me to some sample code that uses messaging? I am using SQL CE on the mobile device.|||Sorry, by messaging I mean events that you can catch within code and then react to. With SQL CE I don't believe this is happening. You can only query the replication object at the completion of the synchronisation process in order to determine what the outcome was (data sent and received)|||Thanks for your response. I did try asynchronous replication and it is working well so far. I need to implement some additional error trapping but I think I have 95% of what I need. It allows me to get a "percent of completion" during the sync process. I can then display this on the screen to my users. The database is VERY large and was taking forever to sync. I really needed some type of progress bar to show the user. Without that status update, it appeared the unit was locked up. Thanks anyway for your reponse.|||Hi,
I am also trying to get a status update on each article during the web synchronization process. Can you please update me on how to monitor the percent complete progress for the replication.
Thanks in advance.
Apurva
Replication Monitor Reporting Error
I am continually having problems with the replication monitor reporting
erronous errors. I have read in the past that this can be resolved by
restarting SQL, but that does not solve my problem because SQL is restarted
nightly on all SQL servers with the commands listed below....
REM Stop SQL Server Agent
net stop sqlserveragent
REM Stop SQL Server
net stop MSSQLServer
REM Start SQL Server
net Start MSSQLServer
REM Start SQL Server Agent
net start sqlserveragent
I am at a loss. I have 17 SQL servers and the problem does not exist on all
of them, but where the error is being reported, it is always the same servers.
HELP!!!
Larry...
Which agent is generating the error.
Normally you can use sp_MSloadresetstatus to fix this problem. I'm not
totally sure if this the name of the proc but do a search like this
select name from master.dbo.sysobjects where name like '%load%' and name
like '%status%' and type='p' and it will show up
"Larry" <Larry@.discussions.microsoft.com> wrote in message
news:AFFB37CD-AB2A-4451-ADFB-53DDBBED8348@.microsoft.com...
>I am continually having problems with the replication monitor reporting
> erronous errors. I have read in the past that this can be resolved by
> restarting SQL, but that does not solve my problem because SQL is
> restarted
> nightly on all SQL servers with the commands listed below....
> REM Stop SQL Server Agent
> net stop sqlserveragent
> REM Stop SQL Server
> net stop MSSQLServer
> REM Start SQL Server
> net Start MSSQLServer
> REM Start SQL Server Agent
> net start sqlserveragent
> I am at a loss. I have 17 SQL servers and the problem does not exist on
> all
> of them, but where the error is being reported, it is always the same
> servers.
> HELP!!!
> Larry...
|||Hilary,
I ran sp_MSload_replication_status, on both the Master dB and the dB
reporting the error, but the pesky red X did not clear up. Any other ideas?
Larry...
erronous errors. I have read in the past that this can be resolved by
restarting SQL, but that does not solve my problem because SQL is restarted
nightly on all SQL servers with the commands listed below....
REM Stop SQL Server Agent
net stop sqlserveragent
REM Stop SQL Server
net stop MSSQLServer
REM Start SQL Server
net Start MSSQLServer
REM Start SQL Server Agent
net start sqlserveragent
I am at a loss. I have 17 SQL servers and the problem does not exist on all
of them, but where the error is being reported, it is always the same servers.
HELP!!!
Larry...
Which agent is generating the error.
Normally you can use sp_MSloadresetstatus to fix this problem. I'm not
totally sure if this the name of the proc but do a search like this
select name from master.dbo.sysobjects where name like '%load%' and name
like '%status%' and type='p' and it will show up
"Larry" <Larry@.discussions.microsoft.com> wrote in message
news:AFFB37CD-AB2A-4451-ADFB-53DDBBED8348@.microsoft.com...
>I am continually having problems with the replication monitor reporting
> erronous errors. I have read in the past that this can be resolved by
> restarting SQL, but that does not solve my problem because SQL is
> restarted
> nightly on all SQL servers with the commands listed below....
> REM Stop SQL Server Agent
> net stop sqlserveragent
> REM Stop SQL Server
> net stop MSSQLServer
> REM Start SQL Server
> net Start MSSQLServer
> REM Start SQL Server Agent
> net start sqlserveragent
> I am at a loss. I have 17 SQL servers and the problem does not exist on
> all
> of them, but where the error is being reported, it is always the same
> servers.
> HELP!!!
> Larry...
|||Hilary,
I ran sp_MSload_replication_status, on both the Master dB and the dB
reporting the error, but the pesky red X did not clear up. Any other ideas?
Larry...
Replication Monitor Question
Hello,
We have some mobile devices that are setup to replicate with our sql 2005 server via web sync. It seems that the devices are added multiple times within replication monitor. Is there a way to purge the bogus items. For example we have a mobile unit labeled as Device12 we have it listed under the subscriptions 5x. I would like to purge four of them as they are not currently being the replicated one.
Device12-A6EE69A0944 is the valid subscription
Device12-EE44D1EF3E24 is an invalid one.
Thanks in advance.
John
You may want to query table dbo.MSsubscriptions in the distribution database to see if it has those extra entries. I'm not saying it's safe to delete them, but I'm guessing that's where sql monitor is pulling those rogue entries from.Replication monitor quesiton.
Is there a way to have SQL alert me when there is either a publisher or a subscriber conflict?
Currently I see under Replication Monitor Merge agents that show details of what is going on including any conflicts. What I want is to be able to set a trigger when either the publisher or the subscriber conflicts goes above zero. This trigger would then send out an E-mail (using BLAT..no Outlook on the SQL Server).
Is there a way to do this?
THANKS!Mind if I thread along
I've been meaning to sort this one out myself when I get time.
It sure is a pain having to keep manually looking for conflicts
GW|||Not at all.
I think I see a partial solution.
Under replication Monitor, it has Replication Alerts.
I added a new alert with:
Object: SQLServer:Replication Merge
Counter: Conflicts/sec
Instance: (choose one)
Alert if counter: rises above
Value: 0
Originally posted by GWilliy
Mind if I thread along
I've been meaning to sort this one out myself when I get time.
It sure is a pain having to keep manually looking for conflicts
GW|||Under replication Monitor, it has Replication Alerts
Sorry I may be being stupid but I can't seem to find this
I'm using SQL2k - Merge Replication
GW|||Oooops sorry
I found it under the Distributers Replication Monitor
Not the Group one that I added
Thx - I'll give it a try
GW|||O Poo !!
Well I forced a conflict & it did'nt fire
does it work for you ?-(
GW|||Originally posted by darrinps
Is there a way to have SQL alert me when there is either a publisher or a subscriber conflict?
Currently I see under Replication Monitor Merge agents that show details of what is going on including any conflicts. What I want is to be able to set a trigger when either the publisher or the subscriber conflicts goes above zero. This trigger would then send out an E-mail (using BLAT..no Outlook on the SQL Server).
Is there a way to do this?
THANKS!
If there is a conflict then there is a conflict_<tablename> table in the database that is replicated. You can check if there is some info in the conflict table(s). If so, you can see what the conflict is
I'm not sure if this works in SQL2000 but it works in SQL7
success, Mark.|||Thx Mark
I have loads of empty system Conflict tables & new tables are created with the first letter incremented from a to b to c etc when conflicts occur.
I have a bad feeling about these & thats one of reasons I need something automating to alert me as soon as conflicts happen.
The closest I can think of doing this is writing a custom conflict resolver that just sends emails but there must be a better way !
GW|||Originally posted by GWilliy
O Poo !!
Well I forced a conflict & it did'nt fire
does it work for you ?-(
GW
Haven't tried it yet. How did you force the conflict?
If this works, it would be a lot better than putting a trigger on every table!|||Haven't tried it yet. How did you force the conflict?
I use Terminal Services to connect roaming clients to Apps that are using Replicated Data - so it was quite easy to manually alter data on both sides at same time.
PCanywhere should work just as well.
If this works, it would be a lot better than putting a trigger on every table!
I did some custom Conflict resolvers last year & never implemented them fully - but setting em up was easy enough - It's just writing an SP for each article & assigning it in the publication properties.
But I'm not sure this is the best way to do alerts - I'm sure it would work though.
Plenty of info on Books Online
Currently I see under Replication Monitor Merge agents that show details of what is going on including any conflicts. What I want is to be able to set a trigger when either the publisher or the subscriber conflicts goes above zero. This trigger would then send out an E-mail (using BLAT..no Outlook on the SQL Server).
Is there a way to do this?
THANKS!Mind if I thread along
I've been meaning to sort this one out myself when I get time.
It sure is a pain having to keep manually looking for conflicts
GW|||Not at all.
I think I see a partial solution.
Under replication Monitor, it has Replication Alerts.
I added a new alert with:
Object: SQLServer:Replication Merge
Counter: Conflicts/sec
Instance: (choose one)
Alert if counter: rises above
Value: 0
Originally posted by GWilliy
Mind if I thread along
I've been meaning to sort this one out myself when I get time.
It sure is a pain having to keep manually looking for conflicts
GW|||Under replication Monitor, it has Replication Alerts
Sorry I may be being stupid but I can't seem to find this
I'm using SQL2k - Merge Replication
GW|||Oooops sorry
I found it under the Distributers Replication Monitor
Not the Group one that I added
Thx - I'll give it a try
GW|||O Poo !!
Well I forced a conflict & it did'nt fire
does it work for you ?-(
GW|||Originally posted by darrinps
Is there a way to have SQL alert me when there is either a publisher or a subscriber conflict?
Currently I see under Replication Monitor Merge agents that show details of what is going on including any conflicts. What I want is to be able to set a trigger when either the publisher or the subscriber conflicts goes above zero. This trigger would then send out an E-mail (using BLAT..no Outlook on the SQL Server).
Is there a way to do this?
THANKS!
If there is a conflict then there is a conflict_<tablename> table in the database that is replicated. You can check if there is some info in the conflict table(s). If so, you can see what the conflict is
I'm not sure if this works in SQL2000 but it works in SQL7
success, Mark.|||Thx Mark
I have loads of empty system Conflict tables & new tables are created with the first letter incremented from a to b to c etc when conflicts occur.
I have a bad feeling about these & thats one of reasons I need something automating to alert me as soon as conflicts happen.
The closest I can think of doing this is writing a custom conflict resolver that just sends emails but there must be a better way !
GW|||Originally posted by GWilliy
O Poo !!
Well I forced a conflict & it did'nt fire
does it work for you ?-(
GW
Haven't tried it yet. How did you force the conflict?
If this works, it would be a lot better than putting a trigger on every table!|||Haven't tried it yet. How did you force the conflict?
I use Terminal Services to connect roaming clients to Apps that are using Replicated Data - so it was quite easy to manually alter data on both sides at same time.
PCanywhere should work just as well.
If this works, it would be a lot better than putting a trigger on every table!
I did some custom Conflict resolvers last year & never implemented them fully - but setting em up was easy enough - It's just writing an SP for each article & assigning it in the publication properties.
But I'm not sure this is the best way to do alerts - I'm sure it would work though.
Plenty of info on Books Online
replication monitor is broken
I have setup transactional replication evertything on one box. but
Publications couldn't show up under computer name from replication monitor
(you can see a red X on that computer name). I try many different ways, but
it still doesn't work.
any one know how to fix it !!!
What is the error message you are getting?
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
"FrankLi" <FrankLi@.discussions.microsoft.com> wrote in message
news:5F19F7E4-8D7A-41DB-B187-642FC9A257B3@.microsoft.com...
>I have setup transactional replication evertything on one box. but
> Publications couldn't show up under computer name from replication monitor
> (you can see a red X on that computer name). I try many different ways,
> but
> it still doesn't work.
> any one know how to fix it !!!
>
|||Hi Hilary,
thanks for your response. this is sql2005, and no error message. I can
connect to publications when I try to connect to distributor, but it will
immediately disconnected.
Frank
"Hilary Cotter" wrote:
> What is the error message you are getting?
> --
> 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
>
> "FrankLi" <FrankLi@.discussions.microsoft.com> wrote in message
> news:5F19F7E4-8D7A-41DB-B187-642FC9A257B3@.microsoft.com...
>
>
Publications couldn't show up under computer name from replication monitor
(you can see a red X on that computer name). I try many different ways, but
it still doesn't work.
any one know how to fix it !!!
What is the error message you are getting?
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
"FrankLi" <FrankLi@.discussions.microsoft.com> wrote in message
news:5F19F7E4-8D7A-41DB-B187-642FC9A257B3@.microsoft.com...
>I have setup transactional replication evertything on one box. but
> Publications couldn't show up under computer name from replication monitor
> (you can see a red X on that computer name). I try many different ways,
> but
> it still doesn't work.
> any one know how to fix it !!!
>
|||Hi Hilary,
thanks for your response. this is sql2005, and no error message. I can
connect to publications when I try to connect to distributor, but it will
immediately disconnected.
Frank
"Hilary Cotter" wrote:
> What is the error message you are getting?
> --
> 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
>
> "FrankLi" <FrankLi@.discussions.microsoft.com> wrote in message
> news:5F19F7E4-8D7A-41DB-B187-642FC9A257B3@.microsoft.com...
>
>
Replication Monitor in VB6
Hello,
I need to continuously monitor the status of a SQL Server 2000 Merge
Replication agent; I was originally hoping to use the SQL Merge ActiveX
control, but that appears to only give me a status when I'm starting and
stopping merge replication from the same VB program. What I need to do is
stop and start replication from Enterprise Manager, but monitor for any
problems with VB. Any ideas? I've can work around the problem by watching
a table for certain records (I forget offhand the name of the table in
distribution) but I'd rather do something a bit more event driven as opposed
to a polling solution like this.
Any help would be greatly appreciated! Thanks!
MBC
Microsoft implements a polling method for this. Basically you would want to
poll the MSdistribution_history and msrepl_errors tables in the distribution
database.
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
"News" <mbcdev@.yahoo.com> wrote in message
news:AOGdnfu-7s9YeRzfRVn-pA@.wideopenwest.com...
> Hello,
> I need to continuously monitor the status of a SQL Server 2000 Merge
> Replication agent; I was originally hoping to use the SQL Merge ActiveX
> control, but that appears to only give me a status when I'm starting and
> stopping merge replication from the same VB program. What I need to do is
> stop and start replication from Enterprise Manager, but monitor for any
> problems with VB. Any ideas? I've can work around the problem by
watching
> a table for certain records (I forget offhand the name of the table in
> distribution) but I'd rather do something a bit more event driven as
opposed
> to a polling solution like this.
> Any help would be greatly appreciated! Thanks!
> MBC
>
I need to continuously monitor the status of a SQL Server 2000 Merge
Replication agent; I was originally hoping to use the SQL Merge ActiveX
control, but that appears to only give me a status when I'm starting and
stopping merge replication from the same VB program. What I need to do is
stop and start replication from Enterprise Manager, but monitor for any
problems with VB. Any ideas? I've can work around the problem by watching
a table for certain records (I forget offhand the name of the table in
distribution) but I'd rather do something a bit more event driven as opposed
to a polling solution like this.
Any help would be greatly appreciated! Thanks!
MBC
Microsoft implements a polling method for this. Basically you would want to
poll the MSdistribution_history and msrepl_errors tables in the distribution
database.
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
"News" <mbcdev@.yahoo.com> wrote in message
news:AOGdnfu-7s9YeRzfRVn-pA@.wideopenwest.com...
> Hello,
> I need to continuously monitor the status of a SQL Server 2000 Merge
> Replication agent; I was originally hoping to use the SQL Merge ActiveX
> control, but that appears to only give me a status when I'm starting and
> stopping merge replication from the same VB program. What I need to do is
> stop and start replication from Enterprise Manager, but monitor for any
> problems with VB. Any ideas? I've can work around the problem by
watching
> a table for certain records (I forget offhand the name of the table in
> distribution) but I'd rather do something a bit more event driven as
opposed
> to a polling solution like this.
> Any help would be greatly appreciated! Thanks!
> MBC
>
replication monitor icon become red color
Hi guys,
I just re-create replication and everything seems like ok. I can replicate
data into subscriber. Only on the replication monitor icon, it has red cross
icon. under it, in the treeview, each item has red color with cross icon. I
check the history, no error, and data has been transfer successfully. Can
some one tell me how to get rid of it? Thanks.
the replication is working fine, only replication monitor become red. The
agent is ok, no error in the history. I don't know why it is red cross on it.
"Iter" wrote:
> Hi guys,
> I just re-create replication and everything seems like ok. I can replicate
> data into subscriber. Only on the replication monitor icon, it has red cross
> icon. under it, in the treeview, each item has red color with cross icon. I
> check the history, no error, and data has been transfer successfully. Can
> some one tell me how to get rid of it? Thanks.
>
|||The replication monitor gets its info from
tempdb.dbo.MSreplication_agent_status and running
sp_MSload_replication_status refreshes this table. As restarting the SQL
Server Service causes the tempdb to be recreated from the model database,
this also removes the problem.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com .
I just re-create replication and everything seems like ok. I can replicate
data into subscriber. Only on the replication monitor icon, it has red cross
icon. under it, in the treeview, each item has red color with cross icon. I
check the history, no error, and data has been transfer successfully. Can
some one tell me how to get rid of it? Thanks.
the replication is working fine, only replication monitor become red. The
agent is ok, no error in the history. I don't know why it is red cross on it.
"Iter" wrote:
> Hi guys,
> I just re-create replication and everything seems like ok. I can replicate
> data into subscriber. Only on the replication monitor icon, it has red cross
> icon. under it, in the treeview, each item has red color with cross icon. I
> check the history, no error, and data has been transfer successfully. Can
> some one tell me how to get rid of it? Thanks.
>
|||The replication monitor gets its info from
tempdb.dbo.MSreplication_agent_status and running
sp_MSload_replication_status refreshes this table. As restarting the SQL
Server Service causes the tempdb to be recreated from the model database,
this also removes the problem.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com .
replication monitor group
Hi,
I am part of the replmonitor role of a distribution
database. I am able to view the agents of the distribution
database but i am unable to start or stop any agent. the
books online says that i should be able to. Reference
Replication/administering and monitoring replication/Tools
for administering and monitoring replication/Replication
Monitor: "You can use Replication Monitor
to: ....Administer agents and subscriptions including
starting and stopping agents and reinitializing
subscriptions".
what did i miss?
Thankx for any help
do a search in BOL for replmonitor and look in Role Requirements. It states that this role can only view. It further states that you can't change anything unless you are also a member of the sysadmin role.
Likewise you can't start or stop agents unless you are a member of the sysadmin role, although this is left unstated in BOL.
In the quote you gave, it does say you can stop and start replication agents using replication monitor, but what is left unsaid is that you need the correct permissions to do so. If you do search on BOL for replmonitor and look in the Replication Monitor
section it does say however "however, the user will not ba ale to administer replication." Starting and stopping agents falls under the umbrella of administering replication.
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
"mona" wrote:
> Hi,
> I am part of the replmonitor role of a distribution
> database. I am able to view the agents of the distribution
> database but i am unable to start or stop any agent. the
> books online says that i should be able to. Reference
> Replication/administering and monitoring replication/Tools
> for administering and monitoring replication/Replication
> Monitor: "You can use Replication Monitor
> to: ....Administer agents and subscriptions including
> starting and stopping agents and reinitializing
> subscriptions".
> what did i miss?
> Thankx for any help
>
I am part of the replmonitor role of a distribution
database. I am able to view the agents of the distribution
database but i am unable to start or stop any agent. the
books online says that i should be able to. Reference
Replication/administering and monitoring replication/Tools
for administering and monitoring replication/Replication
Monitor: "You can use Replication Monitor
to: ....Administer agents and subscriptions including
starting and stopping agents and reinitializing
subscriptions".
what did i miss?
Thankx for any help
do a search in BOL for replmonitor and look in Role Requirements. It states that this role can only view. It further states that you can't change anything unless you are also a member of the sysadmin role.
Likewise you can't start or stop agents unless you are a member of the sysadmin role, although this is left unstated in BOL.
In the quote you gave, it does say you can stop and start replication agents using replication monitor, but what is left unsaid is that you need the correct permissions to do so. If you do search on BOL for replmonitor and look in the Replication Monitor
section it does say however "however, the user will not ba ale to administer replication." Starting and stopping agents falls under the umbrella of administering replication.
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
"mona" wrote:
> Hi,
> I am part of the replmonitor role of a distribution
> database. I am able to view the agents of the distribution
> database but i am unable to start or stop any agent. the
> books online says that i should be able to. Reference
> Replication/administering and monitoring replication/Tools
> for administering and monitoring replication/Replication
> Monitor: "You can use Replication Monitor
> to: ....Administer agents and subscriptions including
> starting and stopping agents and reinitializing
> subscriptions".
> what did i miss?
> Thankx for any help
>
Replication monitor error but no error?!
Hello again,
The root node of my SQL Server replication monitor is showing a red X but
all the actual replications listed underneath are OK. What might be causing
this and how can I get rid of it! My DBA is getting twitchy...
Thanks
Will
If you run profiler and navigate to the replication monitor, you should see
why this is happening. The replication monitor gets its info from
tempdb.dbo.MSreplication_agent_status and running
sp_MSload_replication_status refreshes this table. As restarting the SQL
Server Service causes the tempdb to be recreated from the model database,
this also removes the problem.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com .
The root node of my SQL Server replication monitor is showing a red X but
all the actual replications listed underneath are OK. What might be causing
this and how can I get rid of it! My DBA is getting twitchy...
Thanks
Will
If you run profiler and navigate to the replication monitor, you should see
why this is happening. The replication monitor gets its info from
tempdb.dbo.MSreplication_agent_status and running
sp_MSload_replication_status refreshes this table. As restarting the SQL
Server Service causes the tempdb to be recreated from the model database,
this also removes the problem.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com .
replication monitor error
When Replication monitor shows an error icon, I removed all the publication jobs completedly. After I reconfigured publishing, subscriber,Distribution, why the replication monitor still shows an error icon even though there is no replication job scheduled?
Thank you!
Thanks for using replmonitor.
Would you like provide more detailed repro steps? like how do you remove publicaiton jobs, delete jobs under sqlserveragent, or remove subscriptions? How did you reconfigure everything, did you disable distribution and publication, then recreate them?
Thanks
Yunjing
|||My problem has been resolved by restart sql server agent. Thank you!replication monitor error
When Replication monitor shows an error icon, I removed all the publication jobs completedly. After I reconfigured publishing, subscriber,Distribution, why the replication monitor still shows an error icon even though there is no replication job scheduled?
Thank you!
Thanks for using replmonitor.
Would you like provide more detailed repro steps? like how do you remove publicaiton jobs, delete jobs under sqlserveragent, or remove subscriptions? How did you reconfigure everything, did you disable distribution and publication, then recreate them?
Thanks
Yunjing
|||My problem has been resolved by restart sql server agent. Thank you!Replication Monitor error
Hi, There was trans-Rep setup on a server which was swap out with an new server. The database were backup and then restored. Replicaito was not working. I disable replication and then set the server up for a distribution. With out setting up any publi
shers there is a error on the replication monitor. I can't find where this error is. I did not set anything up yet. Is there a table I can check?
run this proc sp_MSload_replication_status
"Russ" <anonymous@.discussions.microsoft.com> wrote in message
news:8CBC3E88-E6FD-4E6B-B267-A3A5E5AC2F22@.microsoft.com...
> Hi, There was trans-Rep setup on a server which was swap out with an new
server. The database were backup and then restored. Replicaito was not
working. I disable replication and then set the server up for a
distribution. With out setting up any publishers there is a error on the
replication monitor. I can't find where this error is. I did not set
anything up yet. Is there a table I can check?
|||I cant find this stored procedure. Is this somthing that comes with SQL?
-- Hilary Cotter wrote: --
run this proc sp_MSload_replication_status
"Russ" <anonymous@.discussions.microsoft.com> wrote in message
news:8CBC3E88-E6FD-4E6B-B267-A3A5E5AC2F22@.microsoft.com...
> Hi, There was trans-Rep setup on a server which was swap out with an new
server. The database were backup and then restored. Replicaito was not
working. I disable replication and then set the server up for a
distribution. With out setting up any publishers there is a error on the
replication monitor. I can't find where this error is. I did not set
anything up yet. Is there a table I can check?
|||yes, it should be in the master db.
what version of SQL Server r u running.
"Russ" <anonymous@.discussions.microsoft.com> wrote in message
news:374639C1-95A1-48E9-90AC-CCA6C44F8D07@.microsoft.com...
> I cant find this stored procedure. Is this somthing that comes with SQL?
> -- Hilary Cotter wrote: --
> run this proc sp_MSload_replication_status
>
> "Russ" <anonymous@.discussions.microsoft.com> wrote in message
> news:8CBC3E88-E6FD-4E6B-B267-A3A5E5AC2F22@.microsoft.com...
an new
> server. The database were backup and then restored. Replicaito was
not
> working. I disable replication and then set the server up for a
> distribution. With out setting up any publishers there is a error on
the
> replication monitor. I can't find where this error is. I did not
set
> anything up yet. Is there a table I can check?
>
>
shers there is a error on the replication monitor. I can't find where this error is. I did not set anything up yet. Is there a table I can check?
run this proc sp_MSload_replication_status
"Russ" <anonymous@.discussions.microsoft.com> wrote in message
news:8CBC3E88-E6FD-4E6B-B267-A3A5E5AC2F22@.microsoft.com...
> Hi, There was trans-Rep setup on a server which was swap out with an new
server. The database were backup and then restored. Replicaito was not
working. I disable replication and then set the server up for a
distribution. With out setting up any publishers there is a error on the
replication monitor. I can't find where this error is. I did not set
anything up yet. Is there a table I can check?
|||I cant find this stored procedure. Is this somthing that comes with SQL?
-- Hilary Cotter wrote: --
run this proc sp_MSload_replication_status
"Russ" <anonymous@.discussions.microsoft.com> wrote in message
news:8CBC3E88-E6FD-4E6B-B267-A3A5E5AC2F22@.microsoft.com...
> Hi, There was trans-Rep setup on a server which was swap out with an new
server. The database were backup and then restored. Replicaito was not
working. I disable replication and then set the server up for a
distribution. With out setting up any publishers there is a error on the
replication monitor. I can't find where this error is. I did not set
anything up yet. Is there a table I can check?
|||yes, it should be in the master db.
what version of SQL Server r u running.
"Russ" <anonymous@.discussions.microsoft.com> wrote in message
news:374639C1-95A1-48E9-90AC-CCA6C44F8D07@.microsoft.com...
> I cant find this stored procedure. Is this somthing that comes with SQL?
> -- Hilary Cotter wrote: --
> run this proc sp_MSload_replication_status
>
> "Russ" <anonymous@.discussions.microsoft.com> wrote in message
> news:8CBC3E88-E6FD-4E6B-B267-A3A5E5AC2F22@.microsoft.com...
an new
> server. The database were backup and then restored. Replicaito was
not
> working. I disable replication and then set the server up for a
> distribution. With out setting up any publishers there is a error on
the
> replication monitor. I can't find where this error is. I did not
set
> anything up yet. Is there a table I can check?
>
>
Replication Monitor disappears
All,
I have setup transactional replication in our dev environment with
publisher, distributor and subscriber on same box for testing and it was
running fine for some time. When I was setting up replication I had SQL
Service logged on using local system account and sql agent login was dev
admin account.
Yesterday when we have restarted the server, sql service came fine but SQL
Agent did not start. when I tried to start agent it manually it errored
saying login donot have permissions.
When I have checked Agent login, its using same dev admin login which should
have all permissions. Finally I was able to start the SQL Agent service by
retyping dev admin and password from services.
This time though SQL Agent started Replication monitor disappeared from
Enterprise manager. Any suggesstions why it happened..?
This could be a rights issue. Connect to the problem server using the sa
account and see if it shows up.
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
"SQL Replicatio Guy" <SQL Replicatio Guy@.discussions.microsoft.com> wrote in
message news:F6019804-2776-4532-836D-C51156354A45@.microsoft.com...
> All,
> I have setup transactional replication in our dev environment with
> publisher, distributor and subscriber on same box for testing and it was
> running fine for some time. When I was setting up replication I had SQL
> Service logged on using local system account and sql agent login was dev
> admin account.
> Yesterday when we have restarted the server, sql service came fine but SQL
> Agent did not start. when I tried to start agent it manually it errored
> saying login donot have permissions.
> When I have checked Agent login, its using same dev admin login which
should
> have all permissions. Finally I was able to start the SQL Agent service by
> retyping dev admin and password from services.
> This time though SQL Agent started Replication monitor disappeared from
> Enterprise manager. Any suggesstions why it happened..?
>
>
|||Yes, I am sure its rights issue but not sure why my replication monitor did
not come up after I have started the SQL Agent service with dev admin account.
FYI If it helps-
SQL Agent started only when I have retyped dev admin and password.
Regards
"Hilary Cotter" wrote:
> This could be a rights issue. Connect to the problem server using the sa
> account and see if it shows up.
> --
> 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
> "SQL Replicatio Guy" <SQL Replicatio Guy@.discussions.microsoft.com> wrote in
> message news:F6019804-2776-4532-836D-C51156354A45@.microsoft.com...
> should
>
>
I have setup transactional replication in our dev environment with
publisher, distributor and subscriber on same box for testing and it was
running fine for some time. When I was setting up replication I had SQL
Service logged on using local system account and sql agent login was dev
admin account.
Yesterday when we have restarted the server, sql service came fine but SQL
Agent did not start. when I tried to start agent it manually it errored
saying login donot have permissions.
When I have checked Agent login, its using same dev admin login which should
have all permissions. Finally I was able to start the SQL Agent service by
retyping dev admin and password from services.
This time though SQL Agent started Replication monitor disappeared from
Enterprise manager. Any suggesstions why it happened..?
This could be a rights issue. Connect to the problem server using the sa
account and see if it shows up.
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
"SQL Replicatio Guy" <SQL Replicatio Guy@.discussions.microsoft.com> wrote in
message news:F6019804-2776-4532-836D-C51156354A45@.microsoft.com...
> All,
> I have setup transactional replication in our dev environment with
> publisher, distributor and subscriber on same box for testing and it was
> running fine for some time. When I was setting up replication I had SQL
> Service logged on using local system account and sql agent login was dev
> admin account.
> Yesterday when we have restarted the server, sql service came fine but SQL
> Agent did not start. when I tried to start agent it manually it errored
> saying login donot have permissions.
> When I have checked Agent login, its using same dev admin login which
should
> have all permissions. Finally I was able to start the SQL Agent service by
> retyping dev admin and password from services.
> This time though SQL Agent started Replication monitor disappeared from
> Enterprise manager. Any suggesstions why it happened..?
>
>
|||Yes, I am sure its rights issue but not sure why my replication monitor did
not come up after I have started the SQL Agent service with dev admin account.
FYI If it helps-
SQL Agent started only when I have retyped dev admin and password.
Regards
"Hilary Cotter" wrote:
> This could be a rights issue. Connect to the problem server using the sa
> account and see if it shows up.
> --
> 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
> "SQL Replicatio Guy" <SQL Replicatio Guy@.discussions.microsoft.com> wrote in
> message news:F6019804-2776-4532-836D-C51156354A45@.microsoft.com...
> should
>
>
Replication Monitor could not connect to Distributor
Hello Guys,
I have the following scenario:
PC1 : located in Dubai representing my laptop
PC2: located in Denver ,
Both pcs are connected to each other via the internet as i am using Aliases ,they can both access and see each other using SQL Auth.
I want to implement Merge Replication to Synchronize TestDB ,
I have NO DOMAIN connnecting them.
I Created a new publication ,under security i asked the agent to use the Sa account to connect
When launching the rep monitor i get the following error:
"Replication Monitor could not connect to Distributor 'laptop'."
"Login failed for user ''. The user is not associated with a trusted SQL Server connection. (.Net SqlClient Data Provider)"
Both Publisher and Distributer are on my Laptop ,why cant they connect to each other?
Another Question : could i implement Traditional Merge replication to synchronize my DBs or do i need to configure Web Synch in Merge rep to enable connecting via the internet?!
Thanks Guys!
Moodi
First off while you are free to use web synchronization where appropriate you probably can use traditional merge replication.It is probably that you have configured replication monitor to connect to your distributor with an account which does not have the necessary rights to monitor SQL server. Can you ensure that SQL Server is able to authenticate using mixed authentication (right click on it, select properties, select security and ensure that SQL Server and windows authentication is selected. Add an account in the sysadmin role or verify you know the sa password. Then right click on your distributor in Replication Monitor and select remove. Then right click and add it again, this time use the sa account and its password to add it.|||
Thanks Hillary,
i was able to fix this by configuring the property of the connection used to connect to distributer ,it was windows auth. so i changed it to run under SQL auth. now replication monitor can run and show all subscribers but i have another problem.
I get the following error when i try to initialize the subscription located on my USA server :
Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'. [CLIENT: 192.168.1.1]
2007-07-05 11:55:11.00 Logon Error: 18456, Severity: 14, State: 11.
Please note that i am using merge replication via the internet with out web synch. ,when i run the SQL Agent under the local system account i get the above mentioned error although i configured Sa account with the same pwd to be used on both machines.
I created a windows account RepUser on both machines as part of Admin group ,then i configured the agent on both machines to run under this account ,i got the following error:
Login failed for user ''. The user is not associated with a trusted SQL Server connection. [CLIENT: 192.168.1.1]
2007-07-05 11:55:06.15 Logon Error: 17806, Severity: 20, State: 2.
Looks like the SQL agent process account is the one thats being authenticated and NOT the Sa account ,why is this happening?
|||Hi Ali
I am a little lost here, but it sounds like you need to configure your publication to use a ftp snapshot and then configure ftp for anonymous authentication.
HTH
|||Hello Hilary ,
Are u saying that if i have two mahcines replicating via the internet then i should have the snapshot folder accessible via FTP?
Ali
Subscribe to:
Posts (Atom)