Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

The concurrent snapshot for publication 'TESTDB' is not available Expand / Collapse
Author
Message
Posted Friday, November 27, 2009 12:38 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, March 5, 2014 1:58 AM
Points: 4, Visits: 151
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
Posted Sunday, November 29, 2009 1:08 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Wednesday, December 2, 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 »

Add to briefcase

Permissions Expand / Collapse