Home » Microsoft » MB2-708 » What should you recommend?
You are planning the deployment of Microsoft SQL Server for a deployment of Dynamics CRM 2015.
The planned deployment will contain a standby copy of the SQL databases in a remote data center.
You need to recommend a solution for keeping the standby databases up-to-date.
What should you recommend?
A. Database mirroring
B. AlwaysOn Availability Groups
C. File Replication Service (FRS)
D. Transaction log shipping
Correct Answer: D
Explanation/Reference:
SQL Server Log shipping allows you to automatically send transaction log backups from a primary database on a primary server instance to one or more secondary databases on separate secondary server instances. The transaction log backups are applied to each of the secondary databases individually.
Benefits include:
Provides a disaster-recovery solution for a single primary database and one or more secondary databases, each on a separate instance of SQL Server.
