You work as a database administrator at Domain.com. Domain.com is using a SQL Server
2008 instance that contains a database named CK_DB.
CK_DB have 100 GB information where 2 GB of the information is changed daily.
CK_DB has its recovery model set for Simple.
However, Domain.com states that data loss of more than three hours worth of transactions during business
hours is a NO – NO. You need to ensure to use a backup strategy will use the least number of disk
spaces and still complies with Domain.com.
What should you do?
A.
You should consider running a transaction log backup every three hours during business hours.
B.
You should consider running incremental as well as differential database backups daily.
C.
You should consider running an incremental backup every three hours during business hours.
D.
You should consider running a full database backup daily and
a differential backup every three hours during business hours.
E.
You should consider running a full database on a Week.
A differential backup every day.
A transaction log backup every three hours during business hours.
Explanation:
MyNote: full and Differantial Backup ist is better seperated, than do it once a week and diff a day and log in two hours