MSP360 Whitepapers
Essential assets and whitepapers for MSPs and IT Professionals

'; }else{ echo ''; } ?>Microsoft SQL Server Backup and Recovery Guide for MSPs

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.

Full Backup

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.


Vlad M., Chief analystVlad is the chief analyst at CloudBerry. He has spent years tinkering with Microsoft SQL in the form of queries, and servers’ management. He shares his knowledge with CloudBerry so that it can be shared with CloudBerry clients.