SQL Server Performance

Full backup will have the latest T log backup

Discussion in 'ALL SQL SERVER QUESTIONS' started by Ksr39, Aug 14, 2012.

  1. Ksr39 Member

    Hi Experts,
    I have a doubt about full and T log backup,

    Today when I was working on one of my prod server I found that one of my database backup is getting failed due to some space issue. So, I cleared the space and re-ran the job manually. But here I got a doubt that when the full backup is under process there was a T log got generated and the time stamp if I compare it is matching the previous T log (as we configured the T log for every 15 minutes. So, the last was at 12:30 and the recent was at 12:45 and I re-ran the full backup at 12:38) so, my doubt is will the full backup have the data of a recent T log or it’s a new one. The time stamp after completing the full backup was 12:53 and the recent T log was done at 12:45.

    Please let me know how it works..
  2. MichaelB Member

    a full is a full. when the T-log fires it truncates the log when finished. It sounds like you kicked off the full first. then the full has everything since the time it was initialized till the end of its run
    the tlog will have after that time and will not truncate till the full is done:

    see:http://serverfault.com/questions/13099/sql-transaction-log-backups-conflicting-with-full-backups
    or: http://social.msdn.microsoft.com/Fo...e/thread/6182e59d-95d0-4b47-a47b-239460a9c754
    for more information about conflicts.
  3. ghemant Moderator

    In your case, afaik Yes. When you have a full backup which is completed at 12:53 it will have all the data which includes you TLog backup.
  4. Ksr39 Member

    Thank you all for your valuable answers I got the point.

Share This Page