Solved

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

Posted on 2007-11-29
1
972 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
1 Comment
 
LVL 51

Accepted Solution

by:
Vitor Montalvão earned 250 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

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

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

Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
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 ?
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.

615 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