This resource is no longer available
Recovery Model Options in SQL Server
Recovery models available in SQL Server include full-recovery, bulk-log recovery and simple recovery. In this podcast, SQL Server Backup and Recovery expert Greg Robidoux describes each of the three models. Robidoux, president of Edgewood Solutions, will guide you toward making the right recovery model choice for your SQL Server environment.
Once you've determined the type of information being stored in your transaction logs and decided the appropriate recovery model you'll need to choose a backup processing method. Based on the applications being run, backup options for your SQL Server recovery model are:
- Full backups,
- Transaction log backups
- and/or differential backups.
Robidoux will explain each backup type and point you in the right direction to use either one or a combination of backups for your SQL Server.
President and Founder, Edgewood Solutions
- Symantec Corporation
- 23 Oct 2006
- Oct 25, 2006, 09:00 EDT (13:00 GMT)