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 |
|
jnghh
Starting Member
10 Posts |
 Posted - 2008-09-08 : 05:07:43
|
I have gotten the impression (from my own self-study which admittedly may be wrong or incomplete) that it is possible to manually initialize the subscription. Am I wrong?I've tried to do this by:1) setting up my merge publication2) once done, back up the publication database3) transfer this backup to the subscriber database, and restore it there4) setup a subscription between these two databases/servers but specify NOT to initialize immediatelyEverything seems "successful" at this point.However, when I 'View the Synchronization Status', I get this message:"The server 'SubscriberMachineName' is not a Subscriber. (.Net SqlClient Data Provider)"When I view the Replication Monitor, I see the following the details:quote:
Command attempted:{call sp_MSsetconflicttable (N'Bg_Awards', N'MSmerge_conflict_PUBLISH db_Mrg - Merge_Bg_Awards', N'CAT', N'db_Mrg', N'PUBLISH db_Mrg - Merge')}Error messages:Incorrect syntax near 'award_id'. (Source: MSSQLServer, Error number: 102)Get help: http://help/102The merge process was unable to deliver the snapshot to the Subscriber. If using Web synchronization, the merge process may have been unable to create or write to the message file. When troubleshooting, restart the synchronization with verbose history logging and specify an output file to which to write. (Source: MSSQL_REPL, Error number: MSSQL_REPL-2147201001)Get help: http://help/MSSQL_REPL-2147201001
I'm at a loss at how to troubleshoot this. I thought the backup & restore was basically a manual way to completely replicate everything for the first initial stage, but I'm guessing this is wrong .. or I messed up/missed out some step.Help? |
|
|
jisakson
Starting Member
7 Posts |
Posted - 2008-09-08 : 14:19:55
|
| I believe you'll need transfer the snapshot from the publisher instead of the backup (I zip mine up first since I'm dealing with a WAN). Put the snapshot in some directory on your subscriber. Specify an alternate location for the snapshot when you setup the subscription and let it initialize from there. If you want to restore a backup do that before you setup the subscription then as above. I restore a backup first myself to ensure I have everything.Jamie |
 |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-09-12 : 09:29:11
|
| If you are doing with Backup/Restore, you will have to use 'initialize with backup' while setting up subscribers. |
|
|
|
|
|
|
|
|
Merge replication, manual initialization?