Completed
Intro
Class Central Classrooms beta
YouTube videos curated by Class Central.
Classroom Contents
Getting the Most Out of the SQL Server Maintenance Solution
Automatically move to the next video in the Classroom when playback concludes
- 1 Intro
- 2 Session Evaluation
- 3 Intro to the SQL Server Maintenance Soluti
- 4 Improving backup performance • BUFFERCOUNT and MAXTRANSFERSIZE
- 5 Dynamic number of backup files
- 6 Smart transaction log backup • Do more frequent log backups when the volume of transactions is high
- 7 Backup of availability groups - The basics
- 8 The Availability Group Backup Preference
- 9 Pros and cons of backups on the secondary
- 10 Strategies for backup of availability groups
- 11 Checkdb of availability groups - The basics
- 12 Backing up databases in parallel • Very large number of databases Backing up databases sequentially takes a very long time
- 13 Real-world case: Parallel backup
- 14 Checkdb of databases in parallel
- 15 Real-world case: Parallel checkdb
- 16 Backing up to Azure Blob Storage Legacy Azure Blob Type Page Max size per file 1 TB Max total backup size 1 TB Striping
- 17 Backup on SQL Server on Linux • Forward slash instead of backslash in the directory path
- 18 Downloads, Documentation and Issues