Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Nag
Starting Member
1 Post |
 Posted - 2009-11-27 : 02:13:30
|
| HiWe 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 |
|
|
krishnarajeesh
Yak Posting Veteran
67 Posts |
Posted - 2009-11-27 : 13:10:41
|
| Make sure the log reader agent is up. Also try to run the snapshot again.Is the error popping in the initial setup itself ? If yes re-snapshot should solve the issue.Pls let us know the SQL Server versions as well.Thanks,Krishna Rajeeshwww.SQLServer.inBlogs.SQLServer.in |
 |
|
|
bernardy25
Starting Member
3 Posts |
Posted - 2009-12-15 : 02:54:20
|
| Krishnarajeesh has given good solution because I get rid of similiar problem.I hope it also works for you.webcam |
|
|
|
|
|
|
Replication throws strange error