How should you configure your backup and recovery plan?

You work as a database administrator at ABC.com. ABC.com is using a SQL Server 2008
instance that contains a large database named ABC_DB1 that is only updated during working
hours. You have received instructions to create a backup and recovery plan that will ensure that
no data that is older than 1 hour is lost.
How should you configure your backup and recovery plan? (Choose all that apply)

You work as a database administrator at ABC.com. ABC.com is using a SQL Server 2008
instance that contains a large database named ABC_DB1 that is only updated during working
hours. You have received instructions to create a backup and recovery plan that will ensure that
no data that is older than 1 hour is lost.
How should you configure your backup and recovery plan? (Choose all that apply)

A.
You should run a full database backup every Saturday evening.

B.
You should run a full database backup each day after working hours.

C.
You should run a differential backup each day after working hours.

D.
You should run a differential backup every hour during working hours.

E.
You should run an incremental backup each day after working hours.

F.
You should run an incremental backup every hour during working hours.

G.
You should run a transaction log backup every hour during working hours.

Explanation:



Leave a Reply 1

Your email address will not be published. Required fields are marked *


yuri

yuri

.. why not A, C and G ?