You work as the Senior Database Administrator (DBA) at vceguide.com. The company has a main office and 10 branch offices. Each branch office contains a single database server running Microsoft SQL Server 2012. The main office has multiple clustered servers running Microsoft SQL Server 2012.
Your role includes the management of the entire Microsoft SQL Server 2012 infrastructure.
The company runs a custom application that stores data in a large Microsoft SQL Server 2012 database.
The primary database is hosted in the main office. Each branch office SQL Server hosts a copy of the database.
You need to configure a solution that will replicate the entire primary database from the main office SQL Server every weekend.
What should you include in your solution?
A. Transactional Replication
B. Log Shipping
C. Snapshot Replication
D. SQL Server Availability Group
