I’m glad to announce that I will hold a full-day training at SQLSaturday #398 on June, 5 2015 (Krasnodar, Russia). As a Microsoft trainer I’ve taught many courses for DBA but I have not seen a thorough education kit that can make a solid base for disaster recovery. So I’ve started to learn my self how to make it efficiently and now I want to share my knowledge with the students.
On my opinion, a good skills on disaster recovery are impossible without a good understanding of how SQL Server operates with files through the IO subsystem, what is an internal structure of SQL Server files and so on. That’s why I combine two topics into single course.
This training will be about managing database files and transaction log, how to make backup and restore – from simple cases such as full or log backup to a more complicated scenarios like piecemeal restore. We will talk about optimization both the file management and recovery process. Also we mention how to save OLAP databases in SSAS and packages in SSIS.
Short description
Each DBA meets sooner or later the situation when the database grows and it needs to be moved to another disk, the free space is running out unexpectedly, or that is even worse, the hard drive has gone away and it is necessary to restore the database immediately. You have to work very quickly and, that’s the most important, competently.
In this seminar we start from the fundamental basics of SQL Server file management, including data files and transaction log file, take a look how to optimize it.
Then we dive into the world of backups – from simple backup and restore to more complicated scenarios such as piecemeal restore. We reveal the secrets how to make backup/restore process faster.
In practice we will work with a number of “how-to” scenarios concerning file management and database recovery which DBA can meet in his job.
Contents
- Fundamental basics of SQL Server file management (data files and transaction log file);
- Internals of transaction log and optimization;
- Managing file location and size;
- Planning the recovery solution and choosing the recovery model;
- Backup and restore basics;
- Complicated recovery scenarios (file, filegroup and page backup/restore);
- Optimization of backup and restore process;
- Additional features of SQL Server Enterprise version (online restore, piecemeal restore, database snapshot);
- Dealing with system databases;
- Dealing with FileStream;
- Working with the databases of SQL Server Analysis Services and Integration Services.