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.