LGSGEEK

 Profile Answers by LGSGEEK 

• Mar 29th, 2008

 

SIMPLE: Uses full or differential copies of the database. Truncates the
transaction logs automatically. Does not backup the transaction log file(s).
Changes made after the last backup cannot be restored (they are lost).

FULL: Includes both database and transaction log backups. The transaction
logs must be manually truncated. Recovery can be don to a specific point in
time. Only transactions in process at the time of the backup will be lost (those
that are rolled back).

BULK: Includes both database and transaction log backups, but individual
transaction data is not logged for bulk transactions. Transaction logs must be
truncated manually. Restore cannot be done to a specific point in time.

mbhsye786

 Profile Answers by mbhsye786 

• Jan 13th, 2014

 

Full recovery model: This model requires log backups, no data is lots due to lost of data file, can be recover data up to point of failure.

Bulk Log recovery model: Requires log backups. It is similar to full recovery model that allows high performation bulk copy operations. Minimal logging to log file is used. In this point of time recovery is not supported.