SQL Server Bulk Logged Recovery Model
Thursday January 8, 2009
The bulk-logged recovery model is a special-purpose model that works in a similar manner to the full recovery model. The only difference is in the way it handles bulk data modification operations. The bulk-logged model records these operations in the transaction log using a technical known as minimal logging. This saves significantly on processing time, but prevents you from using the point-in-time restore option.
Microsoft recommends that the bulk-logged recovery model only be used for short periods of time. Best practice dictates that you switch a database to the bulk-logged recovery model immediately before conducting bulk operations and restore it to the full recovery model when those operations complete.
Read more about the bulk-logged recovery model and other options in SQL Server Recovery Models.
Microsoft recommends that the bulk-logged recovery model only be used for short periods of time. Best practice dictates that you switch a database to the bulk-logged recovery model immediately before conducting bulk operations and restore it to the full recovery model when those operations complete.
Read more about the bulk-logged recovery model and other options in SQL Server Recovery Models.
Comments
The SQL Server 2000 and 2005 resource depends upon the SQL network name resources and the physical drive resources that store their data. When volume mount points are being used simultaneously with the physical drives, every volume mount point must appear as a cluster resource.