Simple
|
With this method the inactive portion of the transaction log
cannot be retained 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 named 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 named transaction. The Full
Recovery model provides maximum recoverability but it uses the most
log space and does not provide maximum performance for bulk
operations.
|