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 93 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
:D TYSM

coreycathey

  • Member
  • Posts: 333
Reply 3 on: Yesterday
Wow, this really help

« previous next »
 

Did you know?

Symptoms of kidney problems include a loss of appetite, back pain (which may be sudden and intense), chills, abdominal pain, fluid retention, nausea, the urge to urinate, vomiting, and fever.

Did you know?

Bacteria have been found alive in a lake buried one half mile under ice in Antarctica.

Did you know?

It is difficult to obtain enough calcium without consuming milk or other dairy foods.

Did you know?

Though “Krazy Glue” or “Super Glue” has the ability to seal small wounds, it is not recommended for this purpose since it contains many substances that should not enter the body through the skin, and may be harmful.

Did you know?

Pink eye is a term that refers to conjunctivitis, which is inflammation of the thin, clear membrane (conjunctiva) over the white part of the eye (sclera). It may be triggered by a virus, bacteria, or foreign body in the eye. Antibiotic eye drops alleviate bacterial conjunctivitis, and antihistamine allergy pills or eye drops help control allergic conjunctivitis symptoms.

Some organisms used as models in genetic research Some organisms used as models in genetic research
Models for the evolution of hunting by males Models for the evolution of hunting by males
A pharmacist can explain to a patient why medication may look different and ensure the correct ... A pharmacist can explain to a patient why medication may look different and ensure the correct ...
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 ...
Schematic models of an IgG antibody molecule and an Fab fragment Schematic models of an IgG antibody molecule and an Fab fragment
Fluorescence recovery after photobleaching (FRAP) Fluorescence recovery after photobleaching (FRAP)
Video: Mechanisms of capillary exchange (transcytosis & bulk flow)

For a complete list of videos, visit our video library