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. We discuss:
- Full, differential, and transaction log backup types
- Recovery models, including bulk-logged recovery
- Backup automation and verification practices
- Backup destinations: cloud and local