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..
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.
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.