70-332 · Question #66
You need to replicate the SQL Server logins for the database instance in the search farm and ensure that no replication related errors are generated. To which server or servers should you replicate…
The correct answer is A. SPS-DB02 only. In a SharePoint search farm with database mirroring, SQL Server logins must be replicated only to the mirror server to prevent orphaned login errors during failover.
Question
Options
- ASPS-DB02 only
- BSPS-DB03 only
- CSPS-DB01 and SPS-DB02 only
- DSPS-DB01, SPS-DB02, and SPS-DB03
How the community answered
(60 responses)- A57% (34)
- B7% (4)
- C25% (15)
- D12% (7)
Why each option
In a SharePoint search farm with database mirroring, SQL Server logins must be replicated only to the mirror server to prevent orphaned login errors during failover.
SPS-DB02 is the mirror database server for the search farm, and replicating logins to it ensures SQL authentication succeeds during failover without generating orphaned login errors. SQL Server does not automatically synchronize server-level logins from the principal to the mirror, so manual replication to SPS-DB02 alone satisfies the requirement.
SPS-DB03 does not host the mirrored search databases, so replicating logins there would have no effect on preventing replication-related errors in the search farm.
SPS-DB01 is the principal server and already holds the source logins, making replication back to it redundant and unnecessary.
Including SPS-DB03 in the replication targets is unnecessary because it is not part of the mirrored database pair for the search farm and would introduce unneeded administrative overhead.
Concept tested: SQL Server login replication for SharePoint database mirroring
Source: https://learn.microsoft.com/en-us/sharepoint/administration/database-mirroring-and-sharepoint
Topics
Community Discussion
No community discussion yet for this question.