July 20, 2006 at 7:58 am
Would someone help me understand what happens in the following scenario:
I am performing transaction log backup every 15 minutes on a pretty big database. Well during the day this 15 minute transaction log backup is ok but at night time when backup jobs kickin what happens as I have two things running at the same time.. a transaction log backup everything 15 minutes while the database backup is running and it last 2 hours.
so basically when I am done with my backup I have about 8 transaction log backup for that period.
1)is it ok to perform transaction log backup while the db backup is running?
2)is it ok to perform transaction log truncate while the complete backup is running?
3)is it possible for sql server to do transaction log backup during specific windows?
July 20, 2006 at 8:13 am
Well SQL Server does allow to backup transaction log within a window. if someone can comment on the following questions that would be great
1)is it ok to perform transaction log backup while the db backup is running?
2)is it ok to perform transaction log truncate while the complete backup is running?
July 21, 2006 at 9:48 am
When you start a transaction log backup while a full backup is running, it will fail with a serialized process error. It doesn't hurt anything really, but it is annoying.
We have a similar situation. We worked around it by scheduling transaction log backups for 20 hours and left the full-backup window kind of long. If the complete backup finishes within its window, all is well. If the transaction log backup starts before the full backup ends, it fails with a serialized process error, but no other impact.
Hope this helps.
July 21, 2006 at 1:24 pm
sql server 2000 doesn't allow a tlog backup during a full. 2005 allows you to continue to do tlog backups during the full.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply