What is the bulk-logged recovery model?

April 27th, 2008 by uCertify Leave a reply »

The bulk-logged recovery model is used to log most of the bulk operations such as bulk import, bulk insert, index creation, etc. It improves database performance and reduces log space consumption. If a log backup contains bulk operations, the database can be recovered only to the end of the last backup.

  • Share/Bookmark
Advertisement

Leave a Reply

uCertify.com | Our Company | Articles | Contact Us | News and Press Release | uCertify India | Entries (RSS)
MCSE: MCSA, MCTS, MCITP    JAVA Certification: SCJP, SCWCD    Cisco Certification: CCNA, CCENT    A+, Network+, Security+ Project+
Oracle Certification: OCP 11g, OCP 10g, OCA 11g, OCA 10g    CIW foundation    EC-212-32,    CISSP    Photoshop ACE CS4    Adobe Flash ACE, PMP, CAPM
© 2008 uCertify.com. All rights reserved. All trademarks are the property of their respective owners.