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 System: Processor Queue Length counter?
- How to create a trace?
- What is the sp_help stored procedure?
- What is the sp_help_agent_profile stored procedure?
- What is SSAS?