nerdexam
Microsoft

70-332 · Question #7

QUESTION 8 A SharePoint 2010 environment contains a Microsoft SQL Server 2008 R2 database instance named SP-SQL that hosts the databases for the farm. You are upgrading the farm to SharePoint 2013…

The correct answer is B. Run the following Transact-SQL (T-SQL) statement for each content database and service application you plan to upgrade. ALTER DATABASE <database name>SET READ_ONLY. Setting content and service application databases to read-only at the SQL Server level using T-SQL ensures users retain read access to farm contents while the upgrade proceeds.

Maintain a SharePoint environment

Question

QUESTION 8 A SharePoint 2010 environment contains a Microsoft SQL Server 2008 R2 database instance named SP-SQL that hosts the databases for the farm. You are upgrading the farm to SharePoint 2013. You need to ensure that users can access the unmodified farm contents during the upgrade process. What should you do?

Options

  • AIn SQL Server Management Studio, locate the SQL Server instance containing the content databases and service application databases you plan to upgrade. Set the Instance Read-Only value to True.
  • BRun the following Transact-SQL (T-SQL) statement for each content database and service application you plan to upgrade. ALTER DATABASE <database name>SET READ_ONLY;
  • CRun the following command-line tool for each site collection in the content databases you plan to upgrade. Stsadm -o datalock -url<site collection name> -lock readonly
  • DSign in to Central Administration in the SharePoint 2010 environment you plan to upgrade. Set each content database and service application database to Read-Only.

How the community answered

(35 responses)
  • A
    3% (1)
  • B
    86% (30)
  • C
    9% (3)
  • D
    3% (1)

Why each option

Setting content and service application databases to read-only at the SQL Server level using T-SQL ensures users retain read access to farm contents while the upgrade proceeds.

AIn SQL Server Management Studio, locate the SQL Server instance containing the content databases and service application databases you plan to upgrade. Set the Instance Read-Only value to True.

Setting the entire SQL Server instance to read-only affects all databases on the instance, including system databases, which is overly broad and could break other services.

BRun the following Transact-SQL (T-SQL) statement for each content database and service application you plan to upgrade. ALTER DATABASE <database name>SET READ_ONLY;Correct

Running ALTER DATABASE SET READ_ONLY directly against each database in SQL Server Management Studio is the supported method to make SharePoint databases read-only before a database attach upgrade. This preserves user access to existing content in read mode without modifying SharePoint farm settings. It operates at the database engine level, ensuring consistency regardless of which application layer accesses the data.

CRun the following command-line tool for each site collection in the content databases you plan to upgrade. Stsadm -o datalock -url<site collection name> -lock readonly

The Stsadm datalock command locks a site collection at the SharePoint application layer but does not set the underlying SQL database to read-only, which is required for a safe database attach upgrade.

DSign in to Central Administration in the SharePoint 2010 environment you plan to upgrade. Set each content database and service application database to Read-Only.

SharePoint Central Administration does not provide a native UI option to set content databases or service application databases to a read-only state in SQL Server.

Concept tested: SQL Server read-only database configuration for SharePoint upgrade

Source: https://learn.microsoft.com/en-us/sharepoint/upgrade-and-update/copy-databases-to-the-new-farm-for-upgrade-to-sharepoint-2013

Topics

#database read-only#SharePoint 2013 upgrade#T-SQL#content database

Community Discussion

No community discussion yet for this question.

Sign up to join the discussion
Full 70-332 Practice