Log backup happening while a full backup is running

ChrisAVWood

In SQL2000 it would not allow a log backup to happen while a full backup was running. This is now different in SQL2005.

We have just started to use Red Gate SQLBackup 5.2.0.2825 and discovered we had scheduled log backups running while scheduled full backups were running too. I found this out because we had MemToLeave memory problems.

I asked a question on the MS NG's about how SQL2005 maintenance plans handled this situation and I was told: -

The log chain always spans full and diff backups as long as the recovery
mode stays in full. That way if you had a corrupt full backup you can always restore the last good full backup and still have the log restores all the way thru. When you take a Full backup there is always a mini log backup included in the Full backup. That is one way they are able to make the backup consistent from the end of the backup not the beginning. As such it has the last LSN that was successfully applied on recovery. So when you restore a log backup it will check the LSN in the log file against the last one applied and act accordingly.

We are running with a Full recovery model. So my question is how does SQLBackup 5.2 handle the situation when a log backup happens while a full backup is taking place?

Thanks

Chris

petey

SQL Backup doesn't 'pull' the backup data itself. It relies on SQL Server to do that. If SQL 2005 is able to pass transaction log backup data to SQL Backup while a full database backup is running in parallel, then SQL Backup will just process the data as usual.

Perhaps this documentwill make things clearer.

ChrisAVWood

Thats just the information that I needed.

Thanks

Chris