pdanes (4/23/2013)
What state are such backups in when they are taken?
The same state they would be in if they were taken without a full/diff running
What does a transaction log backup give you when it's taken during a full ordifferential backup?
A log backup file containing all the log records since the last log backup, same as it would if it were running at any other time
Where do you start and what do you use if you need to restore such a database?
A full backup that completed before that log backup started and an unbroken chain of log backups from the full backup up to the point you need to restore to.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability