You need to reconfigure the ContentFarm database topology. What should you do? (To answer, drag the appropriate options to the correct location or locations in the answer area. Each option may be…

Question

Explanation

Procedure:

1. Create a clustered SQL Server instance named SP-SQL02 on content databases.
2. Configure SPC-DB02 only as the active node in the cluster.
3. Detach the MySites content databases from the farm.
4. Move the MySites SP-SQL02 only to .
5. After the databases are online, reattach them to the mysites web application.

Notes from explanation:

• MySite content databases must be moved to a separate clustered database instance.
• The new clustered database instance must be created by using existing database servers in ContentFarm.
• All storage resources for both farms are redundant and provide high performance for both read and write operations and support disk mirroring.
• Box 1 (Create a clustered SQL Server instance): Both SQL Server 2012 servers (SPC-DB01 and SPC-DB02).
• Box 2 (Configure active node): From Scenario: SPCS-DB01 has experienced multiple hard drive failures in the last month. So we use SPC-DB02 as the active node.
• Box 3, Box 4, Box 5 (Detach and Move MySites): We move the content databases to the new SQL Server instance.
• Box 6 (Reattach): Reattach to the web application.

No community discussion yet for this question.