nerdexam
Microsoft

70-332 · Question #83

In 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. Run…

The correct answer is B. Set the Instance Read-Only value to True. When preparing SharePoint databases for upgrade, setting the SQL Server instance to read-only is the first protective action after locating the instance in SSMS.

Maintain a SharePoint environment

Question

In 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. 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. Run the following command-line tool for each site collection in the content databases you plan to upgrade. Stsadm -o setsitelock -urKsite collection name> -lock readonly Sign in to Central Administration in the SharePoint 2010 environment you plan to upgrade. Set each content database and service application database to Read-Only. 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.
  • BSet the Instance Read-Only value to True.
  • CRun 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.
  • DRun the following command-line tool for each site collection in the content databases you plan to upgrade. Stsadm -o setsitelock -urKsite collection name> -lock readonly

How the community answered

(22 responses)
  • A
    5% (1)
  • B
    77% (17)
  • C
    14% (3)
  • D
    5% (1)

Why each option

When preparing SharePoint databases for upgrade, setting the SQL Server instance to read-only is the first protective action after locating the instance in SSMS.

AIn SQL Server Management Studio, locate the SQL Server instance containing the content databases and service application databases you plan to upgrade.

Locating the SQL Server instance is a prerequisite discovery step that must be completed before any protective or configuration changes are made, so it is not the action to perform next in the described sequence.

BSet the Instance Read-Only value to True.Correct

After locating the SQL Server instance containing the databases to be upgraded, the immediate next step is to set the Instance Read-Only value to True in SQL Server Management Studio. This protects all databases in the instance from writes during the upgrade preparation phase before individual databases are set to READ_ONLY via T-SQL. Establishing instance-level read-only first ensures no data modifications occur while the upgrade sequence proceeds.

CRun 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.

Running the ALTER DATABASE SET READ_ONLY T-SQL statement is a database-level operation that comes after the instance-level read-only flag has been set, not before it in the correct upgrade preparation sequence.

DRun the following command-line tool for each site collection in the content databases you plan to upgrade. Stsadm -o setsitelock -urKsite collection name> -lock readonly

Running Stsadm to lock site collections is a SharePoint-layer operation that occurs after the SQL Server-level read-only protections have already been established for the content databases.

Concept tested: SharePoint 2010 upgrade database read-only preparation steps

Source: https://learn.microsoft.com/en-us/sharepoint/upgrade-and-update/create-the-sharepoint-2013-farm-for-a-database-attach-upgrade

Topics

#database upgrade#SQL Server read-only#SharePoint upgrade#T-SQL

Community Discussion

No community discussion yet for this question.

Sign up to join the discussion
Full 70-332 Practice