Bulk-logged recovery models-full-SQL Server 2000

Describe the difference between the bulk-logged recovery models, full, and SQL Server 2000 simple?

E

Expert

Verified

With the simple recovery model, no logging is completed. The only technique to recover a database is to restore the database to the last backup. With full recovery, all database alters are logged. With bulk-logged database recovery, all alters are logged except those that cause large log entries.

   Related Questions in Database Management System

©TutorsGlobe All rights reserved 2022-2023.