Checkout the part-2 of my three part article series on SQL Server Database Backups and Recovery Models here, in which you’ll learn about various SQL Server backup types, and how to add and use permanent backup devices and temporary backup devices to perform SQL Server database backups.

In this article, you also learn about differences between various backup options, and how database recovery modes relate to available backup options, and when and how to run a tail-log backup.

This article is published on SSWUG.org.