Author Question: Briefly explain the different SQL Server recovery models. What will be an ideal ... (Read 91 times)

audragclark · **on:** Jul 7, 2018

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 · **Reply #1 on:** Jul 7, 2018

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