This 5-day class is designed to give a solid grounding for database administrators in topics related to high availability and disaster recovery.
The class starts by explaining the methodology for creating a sound HA/DR plan and then covers backup and restore operations in depth. We then move on to a day of consolidation and virtualization, both of which play an important role in availability and cost-cutting. After that, the three major multi-instance technologies (clustering, database mirroring, and replication) are covered. Log shipping will be discussed, but not in any great depth. Finally we examine database snapshots, and end with a long section on consistency checking and recovering from corruptions.
Availability is an area that is critical in today’s environment and all DBAs should be able to design and appropriate availability strategy and coordinate a successful recovery after a disaster.
SQL Server versions covered:
Please note: demos will vary between versions and questions can be answered on any releases from SQL Server 2000 through the current release. And, if you’re a glutton for punishment and have even older versions, feel free to ask questions about any version ever released – someone on the team can probably answer it!
For a detailed agenda click HERE.
If you need help justifying training to your organization, we can help you:
Click HERE to go to our events registration page.
If you have any questions, please contact us.