March 4, 2009 at 12:13 pm
Is there any advantage to backing up the transaction log right before creating a full backup? I am picturing two sequential steps within one maintenance plan. This would supplement the existing scheduled transaction log backups, not replace it.
March 4, 2009 at 12:58 pm
Nothing wrong with doing a t-log backup prior to a full backup. It will truncate the t-log reducing the amount the t-log that may need to be backed up during the full backup to ensure a consistent state.
March 4, 2009 at 3:18 pm
As Lynn stated - nothing wrong with it. For me, it would depend on how often I am running the tlog backups and when the full backup is scheduled.
If I am running tlog backups every 15 minutes - there really is no reason to run an extra one.
If I am running every hour (on the hour), and my backup is scheduled to start on the half-hour - then, maybe.
If I am running every four hours (on the hour beginning at 12:00), the backup is scheduled at 2am - then I could see including another tlog.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy