This topic contains a solution. Click here to go to the answer
« previous next »

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

audragclark

  • Hero Member
  • *****
  • Posts: 579
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


Related Topics

Need homework help now?

Ask unlimited questions for free

Ask a Question
Marked as best answer by a Subject Expert

Ksanderson1296

  • Sr. Member
  • ****
  • Posts: 339
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


audragclark

  • Member
  • Posts: 579
Reply 2 on: Jul 7, 2018
Wow, this really help

Sarahjh

  • Member
  • Posts: 370
Reply 3 on: Yesterday
:D TYSM

« previous next »
 

Did you know?

Egg cells are about the size of a grain of sand. They are formed inside of a female's ovaries before she is even born.

Did you know?

The first successful kidney transplant was performed in 1954 and occurred in Boston. A kidney from an identical twin was transplanted into his dying brother's body and was not rejected because it did not appear foreign to his body.

Did you know?

In inpatient settings, adverse drug events account for an estimated one in three of all hospital adverse events. They affect approximately 2 million hospital stays every year, and prolong hospital stays by between one and five days.

Did you know?

Eating food that has been cooked with poppy seeds may cause you to fail a drug screening test, because the seeds contain enough opiate alkaloids to register as a positive.

Did you know?

After a vasectomy, it takes about 12 ejaculations to clear out sperm that were already beyond the blocked area.

Models of some representative proteins drawn to a common scale Models of some representative proteins drawn to a common scale
Historian James Merrell notes several errors in Benjamin West’s famous 1771 painting, William Penn’s Historian James Merrell notes several errors in Benjamin West’s famous 1771 painting, William Penn’s
What are examples of ideal forms? What are examples of ideal forms?
Secondary Recovery of Oil Secondary Recovery of Oil
Social scientists have not done well at devising theories to explain lovely romantic moments Social scientists have not done well at devising theories to explain lovely romantic moments
If CP for an ideal gas is 35.4 J/molK, which of the following is CV for this gas? If CP for an ideal gas is 35.4 J/molK, which of the following is CV for this gas?
Video: Mechanisms of capillary exchange

For a complete list of videos, visit our video library