Pages

Monday, April 25, 2011

how to turn the sync with backup option on distribution database in replication

We can check the IsSyncwithBackup option of the database involved in replication by running the query:

SELECT
DATABASEPROPERTYEX('room', 'IsSyncWithBackup')

if returns 1 then the property is enable else it will return 0.

Enabling the property by running the following command

sp_replicationdboption

'distribution','sync with backup','true'