Replication stopping.

I am with a problem, therefore I criated a replication of the transacional type to instantaneo and passes some days and stop and it does not replicated more appears the message: "no replicated transactions are available" it is necessary to reinicar snapsh
ot.
Standard SQL 2000 + SP3a
Somebody can help me?
Carla,
sounds like a problem with the log reader.
Can you stop the log reader agent and use sp_replcmds to see if it returns
any rows or an error message.
Regards,
Paul Ibison
|||No replicated transactions are available means 1 of two things
1) all transactions are distributed to the subscriber, ie no updates have been made on the publisher recently
2) as Paul points out the log reader agent has stopped or is hung. To check to see if the log reader agent is hung run a sp_repltrans to see if anything is returned. If something is returned, run it again to see if the results set decreases. If it increas
es your log reader agent is hung, if it decreases or changes your log reader agent is working fine.
Sp_browsereplcmds is good to detect distribution agent problems, but is expensive to run.
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
"Carla" wrote:

> I am with a problem, therefore I criated a replication of the transacional type to instantaneo and passes some days and stop and it does not replicated more appears the message: "no replicated transactions are available" it is necessary to reinicar snap
shot.
> Standard SQL 2000 + SP3a
> Somebody can help me?
sql

Replication latency

Hi,
I have set up a transactional replication on two SQL Server
2000 (SP3) machines.
How do I determine the time it passes between the
transaction was placed in the transaction log at the
Publisher and it has finished at the Subscriber?
--
Many thanks,
OskRun performance monitor... YOu should notice that there will now be new
counters for replication, one of which is latency...
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Osk" <anonymous@.discussions.microsoft.com> wrote in message
news:2aa901c509c4$9d8b76d0$a501280a@.phx.gbl...
> Hi,
> I have set up a transactional replication on two SQL Server
> 2000 (SP3) machines.
> How do I determine the time it passes between the
> transaction was placed in the transaction log at the
> Publisher and it has finished at the Subscriber?
> --
> Many thanks,
> Osk

Replication latency

Hi,
I have set up a transactional replication on two SQL Server
2000 (SP3) machines.
How do I determine the time it passes between the
transaction was placed in the transaction log at the
Publisher and it has finished at the Subscriber?
Many thanks,
Osk
Run performance monitor... YOu should notice that there will now be new
counters for replication, one of which is latency...
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Osk" <anonymous@.discussions.microsoft.com> wrote in message
news:2aa901c509c4$9d8b76d0$a501280a@.phx.gbl...
> Hi,
> I have set up a transactional replication on two SQL Server
> 2000 (SP3) machines.
> How do I determine the time it passes between the
> transaction was placed in the transaction log at the
> Publisher and it has finished at the Subscriber?
> --
> Many thanks,
> Osk

Replication latency

Hi,
I have set up a transactional replication on two SQL Server
2000 (SP3) machines.
How do I determine the time it passes between the
transaction was placed in the transaction log at the
Publisher and it has finished at the Subscriber?
Many thanks,
OskRun performance monitor... YOu should notice that there will now be new
counters for replication, one of which is latency...
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Osk" <anonymous@.discussions.microsoft.com> wrote in message
news:2aa901c509c4$9d8b76d0$a501280a@.phx.gbl...
> Hi,
> I have set up a transactional replication on two SQL Server
> 2000 (SP3) machines.
> How do I determine the time it passes between the
> transaction was placed in the transaction log at the
> Publisher and it has finished at the Subscriber?
> --
> Many thanks,
> Osk