In a mirrored SQL Server configuration, which server hosts the principal copy of the database?

Unlock all questions

This demo includes only 20 questions. Upgrade to access hundreds of questions, flashcards, exam simulations, and disable ads.

Full question bankExam simulationsFlashcards
From $9.99Unlock all

Prepare for the Citrix Virtual Apps and Desktops 7 Administration 1Y0-204 Exam. Access multiple choice questions and flashcards with explanations and hints. Get ready to succeed in your exam!

Multiple Choice

In a mirrored SQL Server configuration, which server hosts the principal copy of the database?

Explanation:
In a mirrored SQL Server setup, one server hosts the primary, or principal, copy of the database. This is the server actively handling client connections and write operations. The other server hosts the mirror copy, which is kept in sync by applying log records sent from the principal. The mirror is a standby that is not writable in normal operation, and only takes over as principal if a failover occurs (with or without a witness, depending on configuration). So the server that contains the primary copy is the Principal SQL Server.

In a mirrored SQL Server setup, one server hosts the primary, or principal, copy of the database. This is the server actively handling client connections and write operations. The other server hosts the mirror copy, which is kept in sync by applying log records sent from the principal. The mirror is a standby that is not writable in normal operation, and only takes over as principal if a failover occurs (with or without a witness, depending on configuration). So the server that contains the primary copy is the Principal SQL Server.

More Multiple Choice Questions
Subscribe

Get the latest from Examzify

You can unsubscribe at any time. Read our privacy policy