70-489 · Question #108
A SharePoint environment contains an instance of Microsoft SQL Server 2008 R2. You plan to migrate data from the existing database to a new instance of SQL Server 2012. You need to configure SQL…
The correct answer is B. On all servers in the farm, configure a SQL Server alias. A SQL Server alias lets all farm servers resolve the old server name to the new SQL Server 2012 instance, requiring no changes to SharePoint's stored connection strings.
Question
A SharePoint environment contains an instance of Microsoft SQL Server 2008 R2. You plan to migrate data from the existing database to a new instance of SQL Server 2012. You need to configure SQL Server to support the migration. You must accomplish this goal without requiring any SharePoint application configuration changes. What should you do?
Options
- AOn the SQL Server, configure a named instance.
- BOn all servers in the farm, configure a SQL Server alias.
- COn all servers in the farm, configure SQL Server database mirroring.
- DCreate a single-node SQL Server cluster.
How the community answered
(63 responses)- A6% (4)
- B76% (48)
- C3% (2)
- D14% (9)
Why each option
A SQL Server alias lets all farm servers resolve the old server name to the new SQL Server 2012 instance, requiring no changes to SharePoint's stored connection strings.
A named instance changes the connection string endpoint, requiring SharePoint to be reconfigured to reference the new instance name explicitly.
Configuring a SQL Server alias on every server in the farm maps the existing server name to the new SQL Server 2012 instance at the OS level. SharePoint stores its connection strings using the server name, so pointing that alias to the new instance allows all connections to succeed without any SharePoint configuration changes. This is the standard supported method for migrating SQL Server in a SharePoint farm.
Database mirroring is a high-availability solution, not a migration path, and still requires configuring a failover partner in SharePoint connection strings.
A single-node cluster uses a virtual network name, which would require updating SharePoint connection strings to point to the new cluster name.
Concept tested: SQL Server alias for SharePoint farm migration
Source: https://learn.microsoft.com/en-us/sharepoint/administration/move-all-databases
Topics
Community Discussion
No community discussion yet for this question.