Backup opinion

[simian336]

If you wanted to do a full backup and clear the transaction logs at virtually the same time, is it better to do a transaction log backup first then do a full backup?

My thinking is that if you clear the tlog (tlog backup) and then a do a full backup, the time between the backup would be covered (if seccussful) by the full backup.

But if you do the full then the tlog, at some later point you might need to recover that tlog just to cover the small length of time between the two.

Thanks

Simi

 

[mrdenny]

You can run transaction log backups while the full backup is running. Full backups are consistent as of the backup job finishing.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / SQL 2005 BI / SQL 2008 DBA / SQL 2008 DBD / SQL 2008 BI / MWSS 3.0: Configuration / MOSS 2007: Configuration)
MCITP (SQL 2005 DBA / SQL 2008 DBA / SQL 2005 DBD / SQL 2008 DBD / SQL 2005 BI / SQL 2008 BI)
MCM (SQL 2008)
MVP

My Blog