Transaction Log Backup during Full backups

• Low Rider

  SSCommitted

  Points: 1502

  More actions

  December 27, 2006 at 5:24 am

  #115667

  Hi

  I have a database backup whoch occurs every 12 hrs at 12:00 Am and 12:00 PM.I also have log backup

  every 15 min.The full backup usually takes a hour or so and i have noticed that the next log backup

  file is generated after the full backup is created.Can anyone tell me why does the transaction log backup not execute while

  the full backup is going on.

  thanks

• Ian Yates

  SSCoach

  Points: 19738

  More actions

  December 27, 2006 at 6:36 am

  #680066

  No need to cross post (or at least include a link to your other pose to keep a consistent and single thread)...  Answer (or at least mine) is here. http://www.sqlservercentral.com/forums/post.aspx?forumid=92&messageid=332909

  Cheers