Wednesday, February 16, 2011 6:37 PM
I have the transactional replication enabled for the reporting purpose.I need to plan for the disaster recovery also.I came across the strategy for backing up the distribution database.Can any one help me in which way or where in can set this option of sync with backup on the distribution database ?
Wednesday, February 16, 2011 7:16 PMModeratorsp_replicationdboption 'distribution','sync with backup','true'
looking for a book on SQL Server 2008 Administration? http://www.amazon.com/Microsoft-Server-2008-Management-Administration/dp/067233044X looking for a book on SQL Server 2008 Full-Text Search? http://www.amazon.com/Pro-Full-Text-Search-Server-2008/dp/1430215941
- Marked As Answer by Alex Feng (SQL)Moderator Sunday, February 27, 2011 9:31 AM
Thursday, February 17, 2011 8:06 AM
Hilary has already given the command.
Just to add to this, make sure that you have proper backup strategy for the distribution database , otherwise the sync with backup option can cause unexpected growth of your publisher db's transaction log.
Monday, November 26, 2012 4:27 PM
If possible can you please help me with the below thread ?
Monday, November 26, 2012 8:46 PM
You do not actually backup the "distribution" database. The "distribution" database only holds temporary unreplicated transactions. You need to backup your published database and init it using that backup.