In the second part of a series, Greg Robidoux presents guidelines that can be used for selecting the appropriate backup and recovery model for SQL Server as well as some important considerations and tips.
Selecting the recovery model and backup options can be simple for your SQL Server implementation. The best scenario is to select the options that provide the most flexibility. The following are some guidelines that can be used for selecting the appropriate backup and recovery model as well as some additional considerations to institute
The article continues at http://searchdatabase.techtarget.com/tip/1,289483,sid13_gci874243,00.html