Briefly explain the different SQL Server recovery models. What ...

[audragclark]

Briefly explain the different SQL Server recovery models.
 
  What will be an ideal response?

Question 2

The DBMS creates ________, also called blocks, on its direct access fields.
 
  A) psuedo records
  B) physical records
  C) secondary file records
  D) key file records

[Ksanderson1296]

Answer to Question 1

SQL Server supports three recovery models: simple, full, and bulk logged. The simple recovery model does not create logs of any changes to the database. This recovery method relies only on complete database backups in the event that the database must be recovered. The full recovery model logs all changes that are made to the database. The bulk-logged recovery model logs all changes to the database except for changes that would result in large log entries.

Answer to Question 2

B

[audragclark]

Thanks for the timely response, appreciate it

[brbarasa]

Great answer, keep it coming