The concurrent snapshot for publication 'TESTDB' is not available

• Nag Y

  SSC Veteran

  Points: 262

  More actions

  November 27, 2009 at 12:38 am

  #385857

  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

• support.sql

  Default port

  Points: 1444

  More actions

  November 29, 2009 at 1:08 pm

  #1085157

  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[/url]
  
  @nalyticsperformance - Microsoft SQL Server & Windows Server Free Data Collector