It is essential every DBA have a proven and reliable backup and recovery plan for their SQL Server database, as data is the life blood of any organization. According to the Gartner report, two out of five enterprises that experience a disaster go out of business within five years.
In this three-part series of Podcasts, SQL Server MVP Hilary Cotter covers all aspects of SQL Server backup and recovery.
In this first Podcast, Cotter outlines overall backup and restore best practices in SQL Server, including:
- Recovery model choices: full, simple and bulk-logged
- Backup types: the advantages of one over the other
- Options for restoring backups
- Partial backup process
SQL Server Research Library
