You work as a database administrator at ABC.com. ABC.com is using a SQL Server 2008
instance that contains a database named ABC_DB. ABC_DB have 200 GB information where 3
GB of the information is changed daily. ABC_DB has its recovery model set for Simple. However,
ABC.com states that data loss of more than one hour for transactions during business hours is a
NO – NO.
How can you setup a backup service while also making sure that minimum disk space is used?
Select two.
A.
Run a daily incremental backup during non-office hours.
B.
Run a daily hybrid backup during non-office hours.
C.
Run a daily full backup during non-office hours.
D.
Run a daily differential backup during non-office hours.
E.
Run a daily transactional log backup during non-office hours.
F.
Run a transaction log backup every three hours during business hours.
G.
Run a differential backup every three hours during business hours.
H.
Run a full backup every three hours during business hours.
I.
Run a hybrid backup every three hours during business hours.
J.
Run a incremental backup every three hours during business hours.
K.
Only one action is required.
Explanation:
A large percentage of the database is changed daily. It is therefore better to use differential
backups during the office hours compared to the standard transactional backups.