January 11, 2011 at 7:14 pm
Hi all,
Currently I'm using transactional replication with updating subscriptions for two computers (1 as publisher + distributor and 1 as subscriber). May I ask what is the bets practice to do database backup for the publication database? As for now, data keeps coming in the two database every second, so I don't want this database backup procedure to interrupt with the logging of data.
Thanks.
Daniel
January 20, 2011 at 10:44 pm
Backing up the database is always helpful to reduce the size of the transactional log file. It depends upon your business requirements and how much data loss is acceptable to you to decide the best backup practices.
Ideally, few months back when i was on a consulting project, I implemented the backup strategy as follows:
1. Performed the full backup daily at 0200 hrs.(Offline hours)
2. Performed the differential backup every 3 hrs.
3. Performed the transactional log backup every 15 minutes.
Once backup strategy is designed then it depends upon you to decide the retention period.
Since the database was production and very important from the business point of view due to which all the copies of backup were transferred to tape and I specified the retention period as 2 days
Also the recovery model of the distribution database can be kept as simple, it will help u greatly to keep the size of the log file as small as possible.
Satnam
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply