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 54 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

shailee

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

« previous next »
 

Did you know?

Looking at the sun may not only cause headache and distort your vision temporarily, but it can also cause permanent eye damage. Any exposure to sunlight adds to the cumulative effects of ultraviolet (UV) radiation on your eyes. UV exposure has been linked to eye disorders such as macular degeneration, solar retinitis, and corneal dystrophies.

Did you know?

The newest statin drug, rosuvastatin, has been called a superstatin because it appears to reduce LDL cholesterol to a greater degree than the other approved statin drugs.

Did you know?

Vital signs (blood pressure, temperature, pulse rate, respiration rate) should be taken before any drug administration. Patients should be informed not to use tobacco or caffeine at least 30 minutes before their appointment.

Did you know?

Many of the drugs used by neuroscientists are derived from toxic plants and venomous animals (such as snakes, spiders, snails, and puffer fish).

Did you know?

Elderly adults are living longer, and causes of death are shifting. At the same time, autopsy rates are at or near their lowest in history.

Two models for dominance of a mutation Two models for dominance of a mutation
This modified model of Easton’s systems theory puts government decision makers as the source of pol This modified model of Easton’s systems theory puts government decision makers as the source of pol
CRISPR/Cas9 Models Evolution CRISPR/Cas9 Models Evolution
Structural models of kinesin I and cytoplasmic dynein Structural models of kinesin I and cytoplasmic dynein
Two models for enzyme–substrate interaction Two models for enzyme–substrate interaction
Climate models the flow of mass and energy Climate models the flow of mass and energy
Video: Polymerase chain reaction PCR - Animation

For a complete list of videos, visit our video library