Looking for anyone with helpful tips on running full, differential and transaction backups. I am currently running a full database backup nightly, a differential backup at noon daily and transaction backups every 30 minutes throughout the day. The full backup takes approx 5 hours, the differential takes up to 9 hours and the transaction log backup takes just a few minutes. My problem is that the differential takes entirely too long to run and it collides with my transaction backups causing them to fail. Anyone have any suggestions on how to avoid this?<br>Thanks in advance...
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Running full, differential and trans log backups
- Thread starter redlam
- Start date
Similar threads
- Locked
- Question
- Locked
- Question