Types of Backups
SQL Server offers several different types of backups you can use to restore a database to a former state. Each of these backups uses a file or set of files to capture the database state. The files are found outside the SQL Server database and can be stored on media such as tape or hard disk.
As described in the following sections, these backup types are available with SQL Server 2012:
Full database backups
Differential database backups
Partial backups
Differential partial backups
File and filegroup backups
Copy-only backups ...
Get Microsoft® SQL Server 2012 Unleashed now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
