Getting the Most Out of the SQL Server Maintenance Solution

This session demonstrates SQL Server Maintenance Solution features for backup and integrity check workflows, including availability groups, parallel operations, Azure Blob Storage, and SQL Server on Linux.

Syllabus

Intro
Session Evaluation
Intro to the SQL Server Maintenance Soluti
Improving backup performance • BUFFERCOUNT and MAXTRANSFERSIZE
Dynamic number of backup files
Smart transaction log backup • Do more frequent log backups when the volume of transactions is high
Backup of availability groups - The basics
The Availability Group Backup Preference
Pros and cons of backups on the secondary
Strategies for backup of availability groups
Checkdb of availability groups - The basics
Backing up databases in parallel • Very large number of databases Backing up databases sequentially takes a very long time
Real-world case: Parallel backup
Checkdb of databases in parallel
Real-world case: Parallel checkdb
Backing up to Azure Blob Storage Legacy Azure Blob Type Page Max size per file 1 TB Max total backup size 1 TB Striping
Backup on SQL Server on Linux • Forward slash instead of backslash in the directory path
Downloads, Documentation and Issues