Replication success but Replication monitor fails.....

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

Replication Problem

Due to network failure (2 hours a day) replication fails between the servers. Normally when network is down for more than an hr, I am not able to restart the replication process by starting the agent. All RED cross marks Appears in the runing services.
Please tell me how do I manage this condition using some frontend deamon that check the replication status, if the replication is down due to network prob or any other reason, daemon tries to restart the replication process.
From http://www.developmentnow.com/g/114_0_0_0_0_0/sql-server-replication.htm
Posted via DevelopmentNow.com Groups
http://www.developmentnow.com
Schedule your agents to restart every 5 minutes. If an agent fails it will
fail for a specific reason. The most common reasons are network
interruptions.
I would poll the msrepl_errors table on the distribution database and have
new errors sent to me via a page. I could then evaluate whether the
automatic scheduled restart will clear the error condition.
http://www.zetainteractive.com - Shift Happens!
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
"Madhur" <raj_max@.hotmail.com> wrote in message
news:6a88e5f5-42b0-4969-99cc-c41781493419@.developmentnow.com...
> Due to network failure (2 hours a day) replication fails between the
> servers. Normally when network is down for more than an hr, I am not able
> to restart the replication process by starting the agent. All RED cross
> marks Appears in the runing services.
> Please tell me how do I manage this condition using some frontend deamon
> that check the replication status, if the replication is down due to
> network prob or any other reason, daemon tries to restart the replication
> process.
> From
> http://www.developmentnow.com/g/114_0_0_0_0_0/sql-server-replication.htm
> Posted via DevelopmentNow.com Groups
> http://www.developmentnow.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 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 .

Replication issues

Hi All ,
I have some concerns with replication
1. if the replication fails 1/2 way , does that mean some data is being
replicated across alrdy or it'll do a roll-back to ensure either it's a
complete replication or no replication ?
2. previously i have already set up the application but in EM , i went to
Replication --> Publications and delete the publication instead of going to
the Replication Monitor --> Publishers --> to delete the publication and
found that i couldn't delete the publication in Replication Monitor -->
Publishers any more
which sp can i used to delete ?
3. i got the error from replication "the subscription has been marked and
must be reintialized . No Sync subscriptions will need to be dropped and
recreated?
- why this error occured , i have set for replication for 72 hours
Kindly advise
tks & rdgs1) this depends. If there is a problem deploying the snapshot, it will be
reapplied, but not rolled back. So if you don't reapply the snapshot after
failure your subscriber database will have some of the replicated objects
and replication metadata in place. If the merge or distribution agent fails
midway it depends on the transactional boundary. Transactional replication
replicates transactions transactionally. So if a transaction with 200
commands (for instance a transaction which updates 200 rows) fails, it will
be completely rolled back. If you are replicating a transaction which causes
a cascading update/delete on the publisher and you have enforced this
cascade for replication, and this transaction fails, it will be rolled back.
For merge replication, if a child record is applied before the corresponding
parent record and the parent is not part of the batch, the agent will fail
and this row will be rolled back, but the successfully applied rows in the
batch will remain. Next time you run the merge agent, this transaction
should succeed if the parent record comes over in the next batch. Merge
replication does not guarantee durability.
2) try sp_droppublication 'publicationname' in the publication database.
3) You should set your history retention to the same value of your
transaction retention (right click on replication monitor, select
distribution properties, and click on the properties button, and set it
there).
--
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
"maxzsim" <maxzsim@.discussions.microsoft.com> wrote in message
news:6A1D3EAE-EE3A-4824-8A97-ACFF7521CEF5@.microsoft.com...
> Hi All ,
> I have some concerns with replication
> 1. if the replication fails 1/2 way , does that mean some data is being
> replicated across alrdy or it'll do a roll-back to ensure either it's a
> complete replication or no replication ?
> 2. previously i have already set up the application but in EM , i went to
> Replication --> Publications and delete the publication instead of going
to
> the Replication Monitor --> Publishers --> to delete the publication and
> found that i couldn't delete the publication in Replication Monitor -->
> Publishers any more
> which sp can i used to delete ?
> 3. i got the error from replication "the subscription has been marked and
> must be reintialized . No Sync subscriptions will need to be dropped and
> recreated?
> - why this error occured , i have set for replication for 72 hours
>
> Kindly advise
> tks & rdgs|||Hi,
I have tried sp_droppublication on the publication db but there's no such
publication to be dropped
when i tried deleting from the replication monitor i got the following
error :
SQL server Enterprise Manager could not retrieve information about
publication 'publication1'
Error 21776 the name 'publication1' was not found in the TransPublication
collection. if the name is a qualified name use [] to seperate various parts
of the name and try again
how could i resove this ?
kindly advise
tks & rdgs
"Hilary Cotter" wrote:
> 1) this depends. If there is a problem deploying the snapshot, it will be
> reapplied, but not rolled back. So if you don't reapply the snapshot after
> failure your subscriber database will have some of the replicated objects
> and replication metadata in place. If the merge or distribution agent fails
> midway it depends on the transactional boundary. Transactional replication
> replicates transactions transactionally. So if a transaction with 200
> commands (for instance a transaction which updates 200 rows) fails, it will
> be completely rolled back. If you are replicating a transaction which causes
> a cascading update/delete on the publisher and you have enforced this
> cascade for replication, and this transaction fails, it will be rolled back.
> For merge replication, if a child record is applied before the corresponding
> parent record and the parent is not part of the batch, the agent will fail
> and this row will be rolled back, but the successfully applied rows in the
> batch will remain. Next time you run the merge agent, this transaction
> should succeed if the parent record comes over in the next batch. Merge
> replication does not guarantee durability.
> 2) try sp_droppublication 'publicationname' in the publication database.
> 3) You should set your history retention to the same value of your
> transaction retention (right click on replication monitor, select
> distribution properties, and click on the properties button, and set it
> there).
> --
> 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
> "maxzsim" <maxzsim@.discussions.microsoft.com> wrote in message
> news:6A1D3EAE-EE3A-4824-8A97-ACFF7521CEF5@.microsoft.com...
> > Hi All ,
> >
> > I have some concerns with replication
> >
> > 1. if the replication fails 1/2 way , does that mean some data is being
> > replicated across alrdy or it'll do a roll-back to ensure either it's a
> > complete replication or no replication ?
> >
> > 2. previously i have already set up the application but in EM , i went to
> > Replication --> Publications and delete the publication instead of going
> to
> > the Replication Monitor --> Publishers --> to delete the publication and
> > found that i couldn't delete the publication in Replication Monitor -->
> > Publishers any more
> > which sp can i used to delete ?
> >
> > 3. i got the error from replication "the subscription has been marked and
> > must be reintialized . No Sync subscriptions will need to be dropped and
> > recreated?
> > - why this error occured , i have set for replication for 72 hours
> >
> >
> > Kindly advise
> > tks & rdgs
>
>

Replication issues

Hi All ,
I have some concerns with replication
1. if the replication fails 1/2 way , does that mean some data is being
replicated across alrdy or it'll do a roll-back to ensure either it's a
complete replication or no replication ?
2. previously i have already set up the application but in EM , i went to
Replication --> Publications and delete the publication instead of going to
the Replication Monitor --> Publishers --> to delete the publication and
found that i couldn't delete the publication in Replication Monitor -->
Publishers any more
which sp can i used to delete ?
3. i got the error from replication "the subscription has been marked and
must be reintialized . No Sync subscriptions will need to be dropped and
recreated?
- why this error occured , i have set for replication for 72 hours
Kindly advise
tks & rdgs
1) this depends. If there is a problem deploying the snapshot, it will be
reapplied, but not rolled back. So if you don't reapply the snapshot after
failure your subscriber database will have some of the replicated objects
and replication metadata in place. If the merge or distribution agent fails
midway it depends on the transactional boundary. Transactional replication
replicates transactions transactionally. So if a transaction with 200
commands (for instance a transaction which updates 200 rows) fails, it will
be completely rolled back. If you are replicating a transaction which causes
a cascading update/delete on the publisher and you have enforced this
cascade for replication, and this transaction fails, it will be rolled back.
For merge replication, if a child record is applied before the corresponding
parent record and the parent is not part of the batch, the agent will fail
and this row will be rolled back, but the successfully applied rows in the
batch will remain. Next time you run the merge agent, this transaction
should succeed if the parent record comes over in the next batch. Merge
replication does not guarantee durability.
2) try sp_droppublication 'publicationname' in the publication database.
3) You should set your history retention to the same value of your
transaction retention (right click on replication monitor, select
distribution properties, and click on the properties button, and set it
there).
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
"maxzsim" <maxzsim@.discussions.microsoft.com> wrote in message
news:6A1D3EAE-EE3A-4824-8A97-ACFF7521CEF5@.microsoft.com...
> Hi All ,
> I have some concerns with replication
> 1. if the replication fails 1/2 way , does that mean some data is being
> replicated across alrdy or it'll do a roll-back to ensure either it's a
> complete replication or no replication ?
> 2. previously i have already set up the application but in EM , i went to
> Replication --> Publications and delete the publication instead of going
to
> the Replication Monitor --> Publishers --> to delete the publication and
> found that i couldn't delete the publication in Replication Monitor -->
> Publishers any more
> which sp can i used to delete ?
> 3. i got the error from replication "the subscription has been marked and
> must be reintialized . No Sync subscriptions will need to be dropped and
> recreated?
> - why this error occured , i have set for replication for 72 hours
>
> Kindly advise
> tks & rdgs
|||Hi,
I have tried sp_droppublication on the publication db but there's no such
publication to be dropped
when i tried deleting from the replication monitor i got the following
error :
SQL server Enterprise Manager could not retrieve information about
publication 'publication1'
Error 21776 the name 'publication1' was not found in the TransPublication
collection. if the name is a qualified name use [] to seperate various parts
of the name and try again
how could i resove this ?
kindly advise
tks & rdgs
"Hilary Cotter" wrote:

> 1) this depends. If there is a problem deploying the snapshot, it will be
> reapplied, but not rolled back. So if you don't reapply the snapshot after
> failure your subscriber database will have some of the replicated objects
> and replication metadata in place. If the merge or distribution agent fails
> midway it depends on the transactional boundary. Transactional replication
> replicates transactions transactionally. So if a transaction with 200
> commands (for instance a transaction which updates 200 rows) fails, it will
> be completely rolled back. If you are replicating a transaction which causes
> a cascading update/delete on the publisher and you have enforced this
> cascade for replication, and this transaction fails, it will be rolled back.
> For merge replication, if a child record is applied before the corresponding
> parent record and the parent is not part of the batch, the agent will fail
> and this row will be rolled back, but the successfully applied rows in the
> batch will remain. Next time you run the merge agent, this transaction
> should succeed if the parent record comes over in the next batch. Merge
> replication does not guarantee durability.
> 2) try sp_droppublication 'publicationname' in the publication database.
> 3) You should set your history retention to the same value of your
> transaction retention (right click on replication monitor, select
> distribution properties, and click on the properties button, and set it
> there).
> --
> 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
> "maxzsim" <maxzsim@.discussions.microsoft.com> wrote in message
> news:6A1D3EAE-EE3A-4824-8A97-ACFF7521CEF5@.microsoft.com...
> to
>
>

Replication issues

Hi All ,
I have some concerns with replication
1. if the replication fails 1/2 way , does that mean some data is being
replicated across alrdy or it'll do a roll-back to ensure either it's a
complete replication or no replication ?
2. previously i have already set up the application but in EM , i went to
Replication --> Publications and delete the publication instead of going to
the Replication Monitor --> Publishers --> to delete the publication and
found that i couldn't delete the publication in Replication Monitor -->
Publishers any more
which sp can i used to delete ?
3. i got the error from replication "the subscription has been marked and
must be reintialized . No Sync subscriptions will need to be dropped and
recreated?
- why this error occured , i have set for replication for 72 hours
Kindly advise
tks & rdgs1) this depends. If there is a problem deploying the snapshot, it will be
reapplied, but not rolled back. So if you don't reapply the snapshot after
failure your subscriber database will have some of the replicated objects
and replication metadata in place. If the merge or distribution agent fails
midway it depends on the transactional boundary. Transactional replication
replicates transactions transactionally. So if a transaction with 200
commands (for instance a transaction which updates 200 rows) fails, it will
be completely rolled back. If you are replicating a transaction which causes
a cascading update/delete on the publisher and you have enforced this
cascade for replication, and this transaction fails, it will be rolled back.
For merge replication, if a child record is applied before the corresponding
parent record and the parent is not part of the batch, the agent will fail
and this row will be rolled back, but the successfully applied rows in the
batch will remain. Next time you run the merge agent, this transaction
should succeed if the parent record comes over in the next batch. Merge
replication does not guarantee durability.
2) try sp_droppublication 'publicationname' in the publication database.
3) You should set your history retention to the same value of your
transaction retention (right click on replication monitor, select
distribution properties, and click on the properties button, and set it
there).
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
"maxzsim" <maxzsim@.discussions.microsoft.com> wrote in message
news:6A1D3EAE-EE3A-4824-8A97-ACFF7521CEF5@.microsoft.com...
> Hi All ,
> I have some concerns with replication
> 1. if the replication fails 1/2 way , does that mean some data is being
> replicated across alrdy or it'll do a roll-back to ensure either it's a
> complete replication or no replication ?
> 2. previously i have already set up the application but in EM , i went to
> Replication --> Publications and delete the publication instead of going
to
> the Replication Monitor --> Publishers --> to delete the publication and
> found that i couldn't delete the publication in Replication Monitor -->
> Publishers any more
> which sp can i used to delete ?
> 3. i got the error from replication "the subscription has been marked and
> must be reintialized . No Sync subscriptions will need to be dropped and
> recreated?
> - why this error occured , i have set for replication for 72 hours
>
> Kindly advise
> tks & rdgs|||Hi,
I have tried sp_droppublication on the publication db but there's no such
publication to be dropped
when i tried deleting from the replication monitor i got the following
error :
SQL server Enterprise Manager could not retrieve information about
publication 'publication1'
Error 21776 the name 'publication1' was not found in the TransPublication
collection. if the name is a qualified name use [] to seperate various p
arts
of the name and try again
how could i resove this ?
kindly advise
tks & rdgs
"Hilary Cotter" wrote:

> 1) this depends. If there is a problem deploying the snapshot, it will be
> reapplied, but not rolled back. So if you don't reapply the snapshot after
> failure your subscriber database will have some of the replicated objects
> and replication metadata in place. If the merge or distribution agent fail
s
> midway it depends on the transactional boundary. Transactional replication
> replicates transactions transactionally. So if a transaction with 200
> commands (for instance a transaction which updates 200 rows) fails, it wil
l
> be completely rolled back. If you are replicating a transaction which caus
es
> a cascading update/delete on the publisher and you have enforced this
> cascade for replication, and this transaction fails, it will be rolled bac
k.
> For merge replication, if a child record is applied before the correspondi
ng
> parent record and the parent is not part of the batch, the agent will fail
> and this row will be rolled back, but the successfully applied rows in the
> batch will remain. Next time you run the merge agent, this transaction
> should succeed if the parent record comes over in the next batch. Merge
> replication does not guarantee durability.
> 2) try sp_droppublication 'publicationname' in the publication database.
> 3) You should set your history retention to the same value of your
> transaction retention (right click on replication monitor, select
> distribution properties, and click on the properties button, and set it
> there).
> --
> 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
> "maxzsim" <maxzsim@.discussions.microsoft.com> wrote in message
> news:6A1D3EAE-EE3A-4824-8A97-ACFF7521CEF5@.microsoft.com...
> to
>
>