PrepAway - Latest Free Exam Questions & Answers

Which feature should you enable in Microsoft SQL Server?

You recently upgraded a SharePoint Server 2010 server farm to SharePoint Server 2013. The farm
contains many sites. The sites contain frequently updated content.
You need to ensure that users can perform demo upgrades of the sites. The solution must minimize the
impact on the users.
Which feature should you enable in Microsoft SQL Server?

PrepAway - Latest Free Exam Questions & Answers

A.
Database mirroring

B.
Log shipping

C.
AlwaysOn Availability Groups

D.
Snapshot

Explanation:
With log shipping, you back up the transaction logs from a primary database to a secondary database on
a separate instance of SQL Server.
Log shipping enables you to automatically send transaction log files for databases from a primary
database server instance to a secondary database server instance. Configure log shipping in SharePoint 2013

2 Comments on “Which feature should you enable in Microsoft SQL Server?

  1. Ivy says:

    Should be D. If the SQL Server Enterprise or Datacenter is used, enable snapshot. Otherwise, backup and restore APIs are used. (Source: Training Kit). Snapshots don’t require an outage.




    0



    0

Leave a Reply