August 24, 2005 at 11:04 am
Our production database backup plan is that
nightly full backup,differential backup every 2 hours, log backup every 15 minutes
I want to log ship to the standby database. I have the following consideration and questions
1) If I just do log shipping, ignore the differential backup on the production, am I running to problem in synchroniztion ?
2) Is is a good idea to initialize the standby after the nightly full backup of production
3) How to apply the differentail backup to the standby
After all, what is the best strartegy here to use klog shipping?
Thanks
August 24, 2005 at 5:52 pm
1) no problem in synchronization.
3) restore full backup, then the last differential backup.
August 25, 2005 at 3:29 am
2) Yes, it's also a test for your backup/recovery procedure.
Each backup you have been able to restore into standby has shown that it is ok in case of an disaster...
Best regards
karl
August 25, 2005 at 8:08 am
The differential backups can be used to initialize the standby database, but there is no need to apply them afterwards.
You're restoring the log backups every 15 minutes, there's nothing in the differential backup that needs to be added. Any transactions that took place between the last log backup and the differential backup will be included in the next log backup.
August 25, 2005 at 4:14 pm
Thanks for you input.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply