Disaster Recovery 2-Day Masterclass

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.

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 I: Fundamentals
- Module 1: Internals
  - Introduction to database structures
  - Introduction to logging and recovery
  - How recovery models affect disaster recovery
- Module 2: Data Storage
  - Choosing a RAID level
  - Storage tuning for fast recovery
Part II: Strategy
- Module 3: Planning a disaster recovery strategy
  - Requirements and limitations
  - Testing
- Module 4: Architecting for recoverability
  - Partial database availability
  - Planning a backup strategy
  - Database snapshots
  - Utilizing high-availability technologies
Part III: Practicalities
- Module 5: Recovering from a disaster with backups
  - Tail-of-the-log backups
  - Determining restore sequence
  - Point-in-time restore
  - Piecemeal restore
  - System databases
- Module 6: Recovering from a disaster without backups
  - Interpreting DBCC CHECKDB output
  - using database repair
  - Using EMERGENCY mode

Save 15% when you register before April 30th, 2010.

Cost: €1,299

Dates: July 7th & 8th 2010

Venue: Microsoft Auditorium EPCD2, South County Business Park, Leopardstown

Click here to register. For further information contact: Sandra@prodata.ie or call 01 2933883

Speakers

Paul S. Randal

In 2007, after 8.5 years on the SQL Server team, Paul left Microsoft to join his wife, Kimberly Tripp, running SQLskills.com and pursuing his passion for presenting and consulting.
Kimberly L. Tripp

Kimberly is a writer/editor for SQL Server Magazine; authored the Indexing chapter for SQL Server 2008 Internals; and tackles real-world problems helping customers around the world.