Whichis the correct answer?

You are managing a SQL Server 2008 instance which includes a database called Products for
Company.com. There is 100 GB information in Products database.2 GB of information is changed
everyday on an average. You have set the recovery model of the Products database Simple.
Business requirements clarify that data loss of more than three hours worth of transactions during
business hours could not run normally. You should make sure that choosing a backup strategy
will utilize the least number of disk spaces through adhering to the business requirements. Which
is the correct answer?

You are managing a SQL Server 2008 instance which includes a database called Products for
Company.com. There is 100 GB information in Products database.2 GB of information is changed
everyday on an average. You have set the recovery model of the Products database Simple.
Business requirements clarify that data loss of more than three hours worth of transactions during
business hours could not run normally. You should make sure that choosing a backup strategy
will utilize the least number of disk spaces through adhering to the business requirements. Which
is the correct answer?

A.
You should run a full database backup once everyday

B.
You should run a full database backup once everyday and then run a differential backup every three hours during business hours.

C.
You should run a differential backup each three hours during business hours.

D.
You should run a transaction log backup each three hours during business hours.



Leave a Reply 0

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