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...
Answer the following statements true (T) or false (F)
1. The du command displays how many times a disk is used. 2. The df command shows the disk failure messages. 3. You can create your own spelling dictionary file. 4. The at command is used to run programs at a specified time. 5. The passwd file contains most of the information system needs to know about a user.
To quickly select all cells in a column, _____.
A. click the column header at the top of the column B. click any cell in the column C. click on the first cell in the column and then drag mouse down D. individually click all cells in the column
Consider the quick sort algorithm as implemented in the text using the sort pattern. Which of the following data characteristics give the fastest run time? Explain.
a) An array sorted into increasing values. b) An array sorted into decreasing values. c) An array of random values d) An array that increases for half the array, then decreases
The term hologram comes from the Greek and literally means_____________
a. complete message b. partial message c. incomplete message d. true message