What should you do to run the backup as soon as possible and get a solution that will negate this type of risk?

You work as a database administrator at Domain.com. Domain.com is using a SQL Server
2008 instance that contains a database. The database at Domain.com contains transaction
information which is for the Web-based order system.

The full recovery model is used on the database. Domain.com is awaiting a few orders that will
come through between 20:00 and 04:00. However, there could be a one hour risk when the
system is running the Database backup.
You need to run the backup as soon as possible and get a solution that will negate this type of risk.

What should you do?

You work as a database administrator at Domain.com. Domain.com is using a SQL Server
2008 instance that contains a database. The database at Domain.com contains transaction
information which is for the Web-based order system.

The full recovery model is used on the database. Domain.com is awaiting a few orders that will
come through between 20:00 and 04:00. However, there could be a one hour risk when the
system is running the Database backup.
You need to run the backup as soon as possible and get a solution that will negate this type of risk.

What should you do?

A.
You should consider running the full backup of the database hourly.
Then set a Check Database Integrity task to run every day to avoid this kind of risk.

B.
You should consider running a full backup daily at 20:00.
Then set a second Back up Database task to run differential backups.
Then you should also consider setting a third Back up Database job to run hourly transaction log backups.

C.
You should consider running a full backup daily at 20:00.
Then set a second Back up Database task to run differential backups.
Then you should also consider running a Check Database Integrity task to run hourly.

D.
You should consider running a full backup daily at 09:00 and 14:00.
Then set a second Back up Database task to do hourly transaction log backups.



Leave a Reply 0

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