We will have an application that will go live soon. I will be using Log Shipping for Disaster Recovery but I am confused about the Job scheduling. The transaction logs will be taken every 10 minutes and is expected to have around 15MB files generated every time. Now if I schedule the Jobs as follows
- Back up Every 10 Minutes -----Network Share
- Copy every 15 Minutes----- Local Disk
- Restore Every 20 Minutes
Now at any point in time there will be a maximum data loss of 10 minutes if the primary goes down. Is there any way to reduce that time and also at the same time make sure the job does not collide with each other... Any expert opinion will be greatly appreciated.