Snapshot is not available
Dear friends
I am a new fellow to replication.What is the problem I am getting is I am not able to create snapShot.Whenever I start Snapshot Agent it is going for half an hour and it will stuck in the case of one view saying like that 'failed to process bulk copy of data from dbo.syncobj_03x666*'.If I am publishing tables only then also I am getting same error.This view created by system.In my case publiher only working as a distributor.I created a SQL username which have access in subscriber & Publisher.Preferably I will be happy if someone suggest what and all are the primary criterias we have to keep in mind while doing Replication
Thanks in Advance
Filson
[714 byte] By [
filson] at [2007-12-23]
you must share your replication snapshot folder
the nt-account used by your sql agent services must have rights
on the replication snapshot folder
I am able to complete snapshot process now.But after that when I am starting synchronising agent it is saying I can't drop table because it's in replication.for datatransfer we have to create any DTS package or Replication itself will do it.Now i am trying Snapshot replication.I will describe steps also done.Tell me what wrong thing I done
1.Install two SQL Server2000 Instances
2.I restore a database in both instance test
2.using publisher wizard i set Core1 as Publisher.create a snapshot folder which having sharing
3.used a administrative windows username setting agents
4.then pull subscription in subscriber
5.i ran snap shot agent
6.after completion i started synchronise spull subcription then I got the error mentioned earlier
i am expecting some suggestion on this
Filson
If the subscriber database was created via a restore, and it previously had replication on top of it, did you specify "Keep_replication" option with the restore statement? If so, the tables will be marked for replication and you cannot drop them, which is what applying snapshot is trying to do.
When restoring the database at the subscriber, choose not to preserve replication.
