You administer a Microsoft SQL Server 2012 instance. The instance contains a database that supports a retail sales application. The application generates hundreds of transactions per second and is online 24 hours per day and 7 days per week. You plan to define a backup strategy for the database. You need to ensure that the following requirements are met:

No more than 5 minutes worth of transactions are lost.

Data can be recovered by using the minimum amount of administrative

effort. What should you do? Choose all that apply.

Question

You administer a Microsoft SQL Server 2012 instance. The instance contains a database that supports a retail sales application. The application generates hundreds of transactions per second and is online 24 hours per day and 7 days per week. You plan to define a backup strategy for the database. You need to ensure that the following requirements are met:

No more than 5 minutes worth of transactions are lost.
Data can be recovered by using the minimum amount of administrative

effort. What should you do? Choose all that apply.

Accepted Answer

B. Create a DIFFERENTIAL database backup every 4 hours. C. Create a LOG backup every 5 minutes. D. Configure the database to use the FULL recovery model. E. Create a FULL database backup every 24 hours.

Answer

A. Configure the database to use the SIMPLE recovery model.

Answer

F. Create a DIFFERENTIAL database backup every 24 hours.

You administer a Microsoft SQL Server 2012 instance. The instance contains a database that supports a retail sales application. The application generates hundreds of transactions per second and is…

Question

Options

How the community answered

Community Discussion