Posted by Erland Sommarskog on 07/12/07 15:44

Brian D (bdaltilio@yahoo.com) writes:
> In MS SQL 2005 when you do a Full Backup does it also backup and
> truncate the transaction logs or do I need to back the transaction
> logs up separately?

You need to backup the transaction log separately. The rationale is that
the last recent backup may have gone lost, or be broken. If the log
backups are OK (and you saved them), you can recover from an older
full backup + the translog backups.




--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

• Next in forum: Re: What free tools should I be using with SQL 2005 to make my life easier?
• Prev in forum: Re: What free tools should I be using with SQL 2005 to make my life easier?
• Thread view: Re: Does a Full Backup include transaction logs

[Reply to this message]