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 |
|
magictech
Starting Member
44 Posts |
 Posted - 2005-02-04 : 15:47:25
|
| I've been trying to manually synchronize Replication subscriptions using Backups and restore for a while now and I can't seems to get it right. I keep getting error messages when I run the output of the sp_scriptpublicationcustomprocs stored procedure on the subscriber database. Is there anyone out there who has successfully implement replication using this method? I really need help. Basically, I started practicing on the Northwind database using the procedure outline in one of Microsoft’s Q article. But each time I does it, I gets several error messages running the output of the sp_scriptpublicationcustomprocs stored procedure. I've also tried with several other databases and still get the same types of error messages. Is this a known problem or are there people out there implementing replication using this procedure. Any input would be greatly appreciated.Regards |
|
|
magictech
Starting Member
44 Posts |
Posted - 2005-02-08 : 11:11:44
|
| Is there anyone on this board who has ever Manually Synchronize Replication Subscriptions by using Backup or Restore? I would really like to know about their experience using this method. Regards |
 |
|
|
sandesh_moghe
Constraint Violating Yak Guru
310 Posts |
Posted - 2008-02-27 : 21:16:09
|
| Sorry for digging in old thread...i think i have answer here:If you run sp_scriptpublicationcustomprocs in grid output (ctrl+D) and then paste it to run, it goes without any error (don't know reason, but it worked for me)Now i have question: Is it a good practice to run that script on publisher so that with every restore subscribers will have those stored procedures and dont need to run script everytime you recreate replication.Any thought?---------------------------Sandesh - The Messenger |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-03-04 : 22:09:12
|
| check this out.http://weblogs.sqlteam.com/dinakar/archive/2007/04/02/60158.aspx |
|
|
|
|
|
|
Manually Synchronize Replication Subscription