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.

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 Initializing a Merge Subscription Without a Snapsh

Author  Topic 

m_z_iqbal
Starting Member

28 Posts

Posted - 2009-04-17 : 08:07:51
Hi all,

I had done the following steps but found problem,

1) Create a publication and generate the snapshot for the publication
2) Perform a backup
3) Restore the backup at the Subscriber

the problem is on step 3, when i restore the Backup there is an option saying "KEEP_REPLICATION" , if i check this option , it will keep the settings of Publisher because the backup came from the Publisher,

and if i don't check this option "KEEP_REPLICATION", the restored Database doesn't have the rowguid column, that publisher created.

What should i do ?

Any help regarding this will be appreciated.


sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2009-04-18 : 00:37:00
If you are generating snapshot,then why are you using backup/restore approach? Just Pull or Push the subscriptions.
Go to Top of Page
   

- Advertisement -