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.



Discussion

No Comment Found

Related InterviewSolutions