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?

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?

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

Show Hint

Leave a Reply 2

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

Ivy

Ivy

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.

Reply

Xiaobin

Xiaobin

Log shipping is just fine, the question requires minimum impact on users

Reply