What is the bulk logged recovery model an what type of restores does it support?
What will be an ideal response?
The bulk logged recovery model sits between the full and simple recovery models and selectively logs changes to the database. In particular, it does not record database changes as individual transactions that occurred due to bulk transactions such as large inserts of data in a bulk copy operation. The bulk logged recovery model does not support point-in-time restores and only allows recovery of data since the last database backup provided that no bulk transaction activity has occurred during that time frame.
You might also like to view...
________ is the abbreviation for the program-integration technology that allows Microsoft Office to share information between programs
Fill in the blank(s) with correct word
The ________ function expands on the AVERAGEIF function by allowing multiple criteria to determine the subset of data
Fill in the blank(s) with correct word