The concurrent snapshot for publication 'TESTDB' is not available

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » SS2K5 Replication » The concurrent snapshot for publication...

The concurrent snapshot for publication 'TESTDB' is not available

Rate Topic

Display Mode

Topic Options

Author

Message

Nag Y

Posted Friday, November 27, 2009 12:38 AM

Forum Newbie

Group: General Forum Members
Last Login: Thursday, February 21, 2013 1:38 AM
Points: 4, Visits: 140

Hi

We have a TESTDB and transaction replication was setup to the subscriber db is REPORTSDB. Replication was working fine.

We have restored production datbase into TESTDB recently and I have setup Transactionl replication to REPORTSDB.

But the replicaiton monotor gives the below error.

"The concurrent snapshot for publication 'TESTDB' is not available because it has not been fully generated or the Log Reader Agent is not running to activate it. If generation of the concurrent snapshot was interrupted, the Snaps"

Infact the snapshot agent was completed. and Log reader agent was running But shows 'no replicated transactions are availble'
But still the above error appears.

The replicaiton for other databases on the same server are running fine.

Please suggest me what needs to done to resolve this issue.

Thanks in Advance.
Nag

Post #825472

support.sql

Posted Sunday, November 29, 2009 1:08 PM

Valued Member

Group: General Forum Members
Last Login: Wednesday, December 02, 2009 2:07 PM
Points: 70, Visits: 32

Microsoft doesn't recommend restore or overwrite a database into replication schema.

You should rebuilt the database replication again to maintain the same SNC into the new database restored.

SNM

Try Free Microsoft SQL Server Data Collector & Performance Monitor.

http://www.analyticsperformance.com

@nalyticsperformance - Microsoft SQL Server & Windows Server Free Data Collector

Post #825906

« Prev Topic | Next Topic »

Permissions