Saved Bookmarks
| 1. |
Explain the difference between the SQL Server 2000 simple, full, and bulk-logged recovery models. |
|
Answer» 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. |
|