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 101 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
Great answer, keep it coming :)

ttt030911

  • Member
  • Posts: 315
Reply 3 on: Yesterday
YES! Correct, THANKS for helping me on my review

« previous next »
 

Did you know?

Giardia is one of the most common intestinal parasites worldwide, and infects up to 20% of the world population, mostly in poorer countries with inadequate sanitation. Infections are most common in children, though chronic Giardia is more common in adults.

Did you know?

The Food and Drug Administration has approved Risperdal, an adult antipsychotic drug, for the symptomatic treatment of irritability in children and adolescents with autism. The approval is the first for the use of a drug to treat behaviors associated with autism in children. These behaviors are included under the general heading of irritability and include aggression, deliberate self-injury, and temper tantrums.

Did you know?

Cucumber slices relieve headaches by tightening blood vessels, reducing blood flow to the area, and relieving pressure.

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?

Hippocrates noted that blood separates into four differently colored liquids when removed from the body and examined: a pure red liquid mixed with white liquid material with a yellow-colored froth at the top and a black substance that settles underneath; he named these the four humors (for blood, phlegm, yellow bile, and black bile).

Three Models for DNA Replication Three Models for DNA Replication
CRISPR/Cas9 Models Evolution CRISPR/Cas9 Models Evolution
What are examples of ideal forms? What are examples of ideal forms?
According to neuroendocrine models of depression, repeated or chronic stress results in overactivity ... According to neuroendocrine models of depression, repeated or chronic stress results in overactivity ...
Teaching Models: Designing Instruction for 21st Century Learners Teaching Models: Designing Instruction for 21st Century Learners
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: Retina

For a complete list of videos, visit our video library