SQL Server Replication - No replicated transactions are available

sql-server sql-server-2008 replication transactional-replication
Arbejdsglæde picture Arbejdsglæde · Nov 14, 2013 · Viewed 11.5k times · Source

I have created a publisher (on sql server 2008 r2), create transaction replication and have created a new database on subscriber sql instance (SQL Server 2012 Express). After I have created a new subscription on SQL Server 2012 Express.

But My new database had't been updated via synchronization.
On server SQL server 2008 r2 via Replication monitor I can see that status is Uninitialized subscription for SQL Server 2012 Express and in details No replicated transactions are available. message

How I can fix it ?

Thanks

Answer

Brandon Williams picture Brandon Williams · Nov 14, 2013

The error states that your subscription is uninitialized.

You need to create the initial snapshot. Right-click the publication under the Local Publications folder at the Publisher and click View Snapshot Agent Status. Then click Start. Once the snapshot is generated, synchronize your subscription to apply the snapshot.

This is covered in Create and Apply the Initial Snapshot.

Related questions

How do I check SQL replication status via T-SQL?

I want to be able to check the status of a publication and subscription in SQL Server 2008 T-SQL. I want to be able to determine if its okay, when was the last successful, sync, etc.. Is this possible?

Read More
Guide for Replication in MS SQL Server 2008

I wonder if anyone know/have a good guide for Replication in MS SQL Server 2008? I want to set up a Replication between two different computers that run MS SQL Server 2008, the master runs on Windows Vista, and the slave …

Read More
Pause SQL server replication temporarily

We have a transactional replication setup using 3 SQL Servers, 1st as publisher, 2nd as distributor, and 3rd as subscriber. We have an activity to change the location of the replicated DB (subscriber) using de-attach and attach method. During this activity, …

Read More