Level: Advanced
Nothing is more frightening to a DBA as getting that wake-up phone call that the system is down, especially when it's a mission critical one. This session will focus on being prepared for, and dealing with, a recovery situation for a SQL Server 2005/2008/2012 database, an instance or an entire server. Topics covered will be backup schemes, partial backups and piecemeal restores, and page-level recovery.
You will learn:
- The different database recovery techniques available
- The different database recovery techniques using different scenarios
- New database recovery techniques in SQL Server 2012