Recovery Model Options in SQL Server
sponsored by Symantec Corporation
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.
(THIS RESOURCE IS NO LONGER AVAILABLE.)