May 5, 2010 at 2:54 pm
GilaMonster (5/5/2010)
Jason P. Burnett (5/4/2010)
True however, I am not sure that would cause any more growth in your log than suspending your log backups during the duration of the full backup.Correct.
It should also be noted that disabling transaction log backups during your full backup opens you up to a further loss of data if the system crashes at that time. If your backup takes 2 hours - and 1 hour 55 minutes after the backup started the system crashes, you could lose all of the changes since the backup started.
Of course, if you can perform a tail log backup (big IF) - you could recover, but that really depends upon how the system crashed and whether or not the log is available.
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 post 16 (of 15 total)
You must be logged in to reply to this topic. Login to reply