What is the bulk-logged recovery model?
Are you preparing for IT certification? With practice questions, study notes, interactive quizzes, tips and technical articles, uCertify PrepKits ensure that you get a solid grasp of core technical concepts to ace your certification exam in first attempt.
What is the bulk-logged recovery model?
Rating:
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.
Rating:
Was this information helpful?
Other articles
- What is the Merge agent?
- What is SSIS?
- What is transaction log?
- What is the RESTORE FILELISTONLY statement?
- What is the bulkadmin fixed server role?