Que: Point out the wrong statement.

a. In Bulk-logged recovery model, few transactions are completely logged
b. The operations that are minimally logged in this recovery model are bulk insert, create index, “bcp” commands, insertion of text , image column and select into query
c. Backups under BULK_LOGGED recovery model will include log records and the data pages changed by bulk operations
d. None of the mentioned
Answer: In Bulk-logged recovery model, few transactions are completely logged

Leave a Comment