eddy (5/27/2008)
if i then also take a full backup using sqlserver on a certain point will the log chain not be broken eg, possible restore with red gates sqlbackup.?
A full backup resets the differential base. A full backup does not truncate transaction logs, therefore does not break a log chain. Doesn't matter if it's native backup or a 3rd party tool.
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