Thursday, December 6, 2007

SQL: Bulk-logged recovery model

One application scenario for Bulk-logged recovery model

In replication topology, the Subscriber database is set to bulk-logged recovery model when the snapshot is being applied. Doing so allows minimal logging of the bulk inserts performed during the application of the snapshot at the subscriber. After the snapshot application, you can change the subscription database to FULL RECOVERY MODEL.