When to use BULK_LOGGED recovery model Having a database in - TopicsExpress



          

When to use BULK_LOGGED recovery model Having a database in bulk_logged recovery model all the time is not recommended, as there’s not much that you gain – you take up a lot of space for LDF file and its backups, but miss the safety full recovery model provides It’s recommended to occasionally switch from full to bulk_logged recovery model, if you want to minimally log bulk operations, complete bulk operations, and then switch back to full recovery model again. This can be done only is you can afford some data loss. If not, you have to stick with full recovery model Minimally logged operations should be captured into a transaction log backup of their own. That means that you have to create a transaction log backup immediately before you switch to bulk_logged recovery model and then again immediately after switching back to full recovery model
Posted on: Mon, 10 Jun 2013 20:35:11 +0000

Trending Topics



Recently Viewed Topics




© 2015