As a managed service provider you realize that Microsoft SQL Server is an application which is critically important for your customers’ business processes. Having a backup in place is therefore a must. In this whitepaper, we will explain SQL Server backup types, recovery models and best practices you should follow.
Below is an abstract from this whitepaper:
SQL Server Backup Types
Microsoft SQL Server supports five types of backup: full, differential, transaction log, tail log, and copy-only backup. We will focus on the first three types in this article, as they are the most common.
A full backup is a complete backup of your SQL Server database. It backs up all of the objects of
the database: tables, procedures, functions, views, indexes, etc. With a full backup, you will be
able to restore a database in exactly the same form as it existed at the time of the backup.
A full backup is the foundation for every other backup type; it must be performed at least once before you can run any of the other types of backups.
SQL Server Recovery Models
There are three types of SQL Server database recovery models: Simple, Full and Bulk-Logged. The database recovery model determines the following:
- How long to keep data in the transaction log
- Which types of backups you can perform
- Which types of database restores you can perform
Learn more about Microsoft SQL Server backup and recovery in the full version of our free whitepaper.