Start networking and exchanging professional insights

Register now or log in to join your professional community.

Follow

Explain the difference between the SQL Server 2000 simple, full, and bulk-logged recovery models.

user-image
Question added by Emad Mohammed said abdalla , ERP & IT Software, operation general manager . , AL DOHA Company
Date Posted: 2014/12/26
Emad Mohammed said abdalla
by Emad Mohammed said abdalla , ERP & IT Software, operation general manager . , AL DOHA Company

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

More Questions Like This

Do you need help in adding the right keywords to your CV? Let our CV writing experts help you.