Explain The Difference Between The Sql Server 2000 Simple, Full, And

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. 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.

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.

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

What Is Lock Granularity?
In General, How Should The Boundaries Of A Transaction Be Defined?
Explain The Meaning Of The Expression Acid Transaction?
Explain The Necessity Of Defining Processing Rights And Responsibilities. How Are Such Responsibilities Enforced?
Explain How A Database Could Be Recovered Via Reprocessing. Why Is This Generally Not Feasible?
Define Rollback And Roll Forward?
Why Is It Important To Write To The Log Before Changing The Database Values?
Explain The Difference Between A Database Administrator And A Data Administrator?
What Is The Foreign Key?
What Is A Candidate Key?