SQL Server Replication - No replicated transactions are available

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.