Disaster Recovery - 2 day Master Class
Location: Microsoft Auditorium, EPDC2, Leopardstown
Date: July 7th & 8th 2010
Cost: €1,299
Delivered by internationally acclaimed SQL gurus, Paul S Randal & Kimberly L Tripp, this level 400 course is suited to people who have a number of years hands-on experience with the technologies and concepts or to those who have already completed a level 300 course in this area. It is a natural extension on the material covered in the SQL Immersion syllabus. The course will be delivered over the course of two intense days.
Register Now
Disasters happen - plain and simple. When disaster strikes a database you're responsible for, are you going to be able recover within the down-time and/or data-loss limits your company requires? This workshop isn't about how to achieve high-availability, it's about how to prevent or overcome the obstacles you're likely to hit when trying to recover from a disaster such as not having the right backups, not having valid backups, or not having any backups! How do you come up with a good and reliable backup strategy? How can you architect a database to allow easier recovery? What can you do to limit the damage a disaster causes? In this demo-heavy workshop, you will see a ton of tips, tricks, and techniques that have been learned from years of experience helping customers plan for and recover from disasters.
Part 1 - Fundamentals
- M1: Internals
- Introduction to database structures
- Introduction to logging and recovery
- How recovery models affect disaster recovery
- M2: Data Storage
- Choosing a RAID level
- Storage tuning for fast recovery
Part 2 - Strategy
- M3: Planning a disaster recovery strategy
- Requirements and limitations
- Testing
- M4: Architecting for recoverability
- Monitoring for corruption
- Partial database availability
- Planning a backup strategy
- Database snapshots
- Utilizing high-availability technologies
Part 3 - Practicalities
- M5: Recovering from a disaster with backups
- Tail-of-the-log backups
- Determining restore sequence
- Point-in-time restore
- Piecemeal restore
- System databases
- M6: Recovering from a disaster without backups
- Interpreting DBCC CHECKDB output
- Using database repair
- Using EMERGENCY mode
Register Now