In China, we always setup one-way site replication for our client’s backup onair machine, so that the backup onair machine will not affect the main site. We used the SQL script to delete the backupsite->mainsite siteconnection from SiteConnection table, script like this:

1
2

Select * from [site]
Select * from [siteconnection]

After we get the backupsite->mainsite siteconnection UniversalIdentifier, we run this script:

1

delete from SiteConnection where UniversalIdentifier = 'Backup->Main UniversalIdentifier'

Then restart the site replication service in main site and backup site machine.

Now we can enable “Site Replication Pubilsher Service” and “Site Replication Receiver Service” independently. My question is do we need to delete the backupsite->mainsite siteconnection from SiteConnection table if we have only enabled “Site Replication Pubilsher Service” in the main site and only enabled “Site Replication Receiver Service” in the backup site?