Bayt.com

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.

Operating Systems ERP Computer Science
user-image
Question added by Emad Mohammed said abdalla , ERP & IT Software, operation general manager . , AL DOHA Company
Date Posted: 2014/12/26
Upvote (0) Views (1) Followers (1) Answers (1) Report Question
Write an Answer
Register now or log in to answer.
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.

Write Your Answer
More Questions Like This