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

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

  1. Lloyd says:

    I would go for D: snapshot.

    https://technet.microsoft.com/en-us/library/ff191199.aspx#Anchor_2

    If you have an Enterprise version of SQL Server, the Create Upgrade Evaluation Site Collections job timer takes a snapshot of the database and reads the data from the snapshot to a destination database (with the source database being the default target). This doesn’t affect the read-only status of the source site throughout the whole process.




    0



    0

Leave a Reply