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

mcarey591

  • Member
  • Posts: 365
Reply 3 on: Yesterday
Great answer, keep it coming :)

« previous next »
 

Did you know?

The people with the highest levels of LDL are Mexican American males and non-Hispanic black females.

Did you know?

More than nineteen million Americans carry the factor V gene that causes blood clots, pulmonary embolism, and heart disease.

Did you know?

In Eastern Europe and Russia, interferon is administered intranasally in varied doses for the common cold and influenza. It is claimed that this treatment can lower the risk of infection by as much as 60–70%.

Did you know?

According to research, pregnant women tend to eat more if carrying a baby boy. Male fetuses may secrete a chemical that stimulates their mothers to step up her energy intake.

Did you know?

Every flu season is different, and even healthy people can get extremely sick from the flu, as well as spread it to others. The flu season can begin as early as October and last as late as May. Every person over six months of age should get an annual flu vaccine. The vaccine cannot cause you to get influenza, but in some seasons, may not be completely able to prevent you from acquiring influenza due to changes in causative viruses. The viruses in the flu shot are killed—there is no way they can give you the flu. Minor side effects include soreness, redness, or swelling where the shot was given. It is possible to develop a slight fever, and body aches, but these are simply signs that the body is responding to the vaccine and making itself ready to fight off the influenza virus should you come in contact with it.

Some organisms used as models in genetic research Some organisms used as models in genetic research
Some organisms used as models in genetic research Some organisms used as models in genetic research
Finish by holding the hand briefly. Finish by holding the hand briefly.
Primary Recovery of Oil Primary Recovery of Oil
Secondary Recovery of Oil Secondary Recovery of Oil
Teaching Models: Designing Instruction for 21st Century Learners Teaching Models: Designing Instruction for 21st Century Learners
Video: Role of complement proteins

For a complete list of videos, visit our video library