About recovery strategies
SQL Server provides the following levels for database recovery. Each level has different implications for both backup performance and for the granularity of recovery.
These levels are as follows:
Simple | With this method you cannot retain the inactive portion of the transaction log beyond the database checkpoint. This method provides for minimal usage of log space. However, the database can only be restored to the last full backup. Transaction log restores, including point in time recovery and marked transaction recovery are not supported. In addition, maximum performance is provided for bulk operations, such as (Create Index, Select Into, and Bulk Copy) because they are not logged. |
Full | With this method, the inactive portion of the transaction log is retained until it is truncated, which normally occurs when it is backed up. The transaction log can then be used to stage a recovery either to a point in time or to a marked transaction. The Full Recovery model provides maximum recoverability but it uses the most log space and does not provide maximum performance for bulk operations. |
Bulk-Logged | This method is identical to the Full Recovery model except that bulk operations are not logged and thus cannot be recovered. |