70-489 · Question #107
You are migrating a SharePoint Server 2010 My Site site collection to SharePoint Server 2013 by using the database attach method. You copy the content databases to the SharePoint 2013 farm. You need…
The correct answer is B. Run the Windows PowerShell cmdlet Test-SPContentDatabase on the SharePoint 2013 farm. Before upgrading a content database in a database attach migration, Test-SPContentDatabase must be run on the destination SharePoint 2013 farm to identify any missing components.
Question
You are migrating a SharePoint Server 2010 My Site site collection to SharePoint Server 2013 by using the database attach method. You copy the content databases to the SharePoint 2013 farm. You need to verify that all required objects have been successfully added to the SharePoint 2013 farm before upgrading the content database. What should you do?
Options
- AIn the SharePoint 2013 site collection, run the site collection health checks.
- BRun the Windows PowerShell cmdlet Test-SPContentDatabase on the SharePoint 2013 farm.
- CRun the Windows PowerShell cmdlet Test-SPContentDatabase on the SharePoint 2010 farm.
- DIn the SharePoint 2010 site collection, run the site collection health checks.
- ERun the Windows PowerShell cmdlet Mount-SPContentDatabase on the SharePoint 2010 farm.
- FRun the Windows PowerShell cmdlet Mount-SPContentDatabase on the SharePoint 2013 farm.
How the community answered
(38 responses)- B92% (35)
- D5% (2)
- E3% (1)
Why each option
Before upgrading a content database in a database attach migration, Test-SPContentDatabase must be run on the destination SharePoint 2013 farm to identify any missing components.
Site collection health checks run against an already-mounted and upgraded site collection in SharePoint 2013, not against a database that has not yet been attached or upgraded.
Test-SPContentDatabase analyzes a content database against the SharePoint 2013 farm without actually mounting or modifying it, reporting any missing features, site definitions, or assemblies that must be present before a successful upgrade can occur. Running it on the 2013 farm is correct because that is the target environment where the components must exist.
Running Test-SPContentDatabase on the SharePoint 2010 farm checks compatibility against the 2010 environment, not the 2013 target farm, so it cannot verify that 2013 has all required objects.
Health checks in the SharePoint 2010 site collection validate the source environment and do not verify readiness of the SharePoint 2013 destination farm.
Mount-SPContentDatabase on the SharePoint 2010 farm is not a valid step; mounting should only occur on the destination 2013 farm and only after verification with Test-SPContentDatabase.
Mount-SPContentDatabase on the SharePoint 2013 farm is the step that actually attaches and upgrades the database, which should only be done after Test-SPContentDatabase confirms all required objects are present.
Concept tested: Test-SPContentDatabase pre-upgrade verification in database attach migration
Source: https://learn.microsoft.com/en-us/powershell/module/sharepoint-server/test-spcontentdatabase
Topics
Community Discussion
No community discussion yet for this question.