Thursday, October 18, 2007

FULL RECOVERY vs. Bulk-logged Recovery

Full Recovery mode supports point-in-time (marked transaction) restore.

Bulk-logged Recovery mode does not support this feature. It is for temporary use. Before you bulk insert, create a snapshot of your database and then configure your database with bulk-logged recovery mode, bulk insert the data into your empty table. Last, configure your database back to FULL RECOVERY MODE and create a full backup of your database.