This article is excerpted from the upcoming book SQL Server 2008 Administration in Action by Rod Colledge and published by Manning Publications. It addresses the various types of server backups: full backup, differential backup, transaction log backup, and COPY_ONLY backup. For the table of contents, the Author Forum, and other resources, go to http://manning.com/colledge/.

Backup types (PDF)