SQL Server Recovery Models

SQL Server provides three different recovery models that allow you to specify the way SQL Server manages log files and prepares your enterprise for a disaster. Each of these models represents a different approach to balancing the tradeoff between conserving disk space and providing for granular disaster recovery options. The three disaster recovery models supported by SQL Server are:

• Full recovery model
• Simple recovery model
• Bulk-logged recovery model

Read the full article: SQL Server Recovery Models