Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Replication jobs showing a status of "No replicated Transactions are available" - why?

Posted on 2007-11-29
1
Medium Priority
?
1,035 Views
Last Modified: 2010-05-18
Hi there

Have setup replication jobs on serverA going to serverB.  When I initially ran the Snapshot and Distribution jobs the jobs worked fine.  The second time the Distribution job ran it is showing a status of "IDLE" when i would expect "SUCCEEDED"  but the Last Action column is showing the text "No replicated Transactions are available" when I would expect it to show "applied the snapshot to the subscriber"

Anyone have any idea why this is happening.
0
Comment
Question by:BravehearT-1326
1 Comment
 
LVL 52

Accepted Solution

by:
Vitor Montalvão earned 750 total points
ID: 20372822
Looks like nothing have changed since first snapshot, so SQL Server see no needs to make a new snapshot.
0

Featured Post

Vote for the Most Valuable Expert

It’s time to recognize experts that go above and beyond with helpful solutions and engagement on site. Choose from the top experts in the Hall of Fame or on the right rail of your favorite topic page. Look for the blue “Nominate” button on their profile to vote.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this article we will learn how to fix  “Cannot install SQL Server 2014 Service Pack 2: Unable to install windows installer msi file” error ?
An alternative to the "For XML" way of pivoting and concatenating result sets into strings, and an easy introduction to "common table expressions" (CTEs). Being someone who is always looking for alternatives to "work your data", I came across this …
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
Viewers will learn how the fundamental information of how to create a table.

876 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question