70-489 · Question #114
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…
The correct answer is A. Run the following Transact-SQL (T-SQL) statement for each content database and service application. During a SharePoint 2010 to 2013 database-attach upgrade, setting content databases to read-only via T-SQL keeps the legacy farm live and accessible to users while those databases are being migrated to the new farm.
Question
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?
Exhibit
Options
- ARun the following Transact-SQL (T-SQL) statement for each content database and service application
- BRun the following command-line tool for each site collection in the content databases you plan
- CRun the following Windows PowerShell cmdlets for each web application in the SharePoint 2010
- DRun the following Transact-SQL (T-SQL) statement for each content database and service application
How the community answered
(34 responses)- A74% (25)
- B3% (1)
- C9% (3)
- D15% (5)
Why each option
During a SharePoint 2010 to 2013 database-attach upgrade, setting content databases to read-only via T-SQL keeps the legacy farm live and accessible to users while those databases are being migrated to the new farm.
Executing a T-SQL ALTER DATABASE ... SET READ_ONLY statement against each content database and service application database forces SQL Server to reject write operations, allowing the existing SharePoint 2010 farm to continue serving read requests to users uninterrupted while the databases are detached, copied, and attached to the SharePoint 2013 farm. This is the prescribed database-attach upgrade approach that prevents data changes mid-migration and ensures farm contents remain unmodified and accessible throughout the process.
Running a command-line tool per site collection operates at the SharePoint application layer and does not place the underlying SQL databases into read-only mode, so the farm content cannot be guaranteed to remain unmodified during the upgrade.
Windows PowerShell cmdlets targeting each web application in SharePoint 2010 manage SharePoint-level configuration but do not set the SQL Server databases to READ_ONLY, which is the SQL-level mechanism required to preserve content integrity and continued user access during a database-attach upgrade.
As presented, this option is textually identical to option A and appears to be a duplicate or data error in the question; the correct action is the T-SQL READ_ONLY approach described in option A.
Concept tested: SharePoint database-attach upgrade read-only SQL configuration
Source: https://learn.microsoft.com/en-us/sharepoint/upgrade-and-update/upgrade-content-databases
Topics
Community Discussion
No community discussion yet for this question.
