Full backups while using transaction log shipping

jimc5240 · June 1, 2010 12:24PM

I have transaction log shipping running without a problem. However, I still need to have a full backup done every night for archive purposes.

When I try to schedule a full backup using SB6, I get a failure that essentially says the database has a conflict with the backup/restore functions. I have figured out that the SQL Agent jobs are overlapping and that's the problem. I can however, use a maintenance plan to back up the database provided I squeeze it in between the agent backup and restore on the transaction log shipping. I'd prefer to use SB6 because of the encryption and compression. Is there any way to do both the transaction log shipping and a full backup schedule simultaneously in SB6?

Thanks

Eddie D · June 2, 2010 1:13PM

Thank you for your post into the forum.

Unfortunately you cannot run a Full backup and a Log backup simultaneously. What ever job starts first will prevent the other starting or running successfully.

I recommend that you suspend the Log Backup jobs for the period of the Full Backup. So for example, the Full Backup normally takes 90 minutes to complete and starts at 22:00. You perform a Log backup every 15 minutes (00, 15, 30 and 45 minutes past the hour). Modify the Log Backup schedule so that the last log backup in the 24 hour period takes place at 21:45 and they recommence at 23:45 which will allow a 2 hour period for the Full Backup to run.

Many Thanks
Eddie

Full backups while using transaction log shipping

Comments

Product Learning

Community Forums

Events & Friends

Simple Talk