You work as a database administrator at Domain.com. Domain.com is using a SQL Server
2008 instance that contains three databases named CK_DB1, CK_DB2 and CK_DB3. Each of
these databases runs on different servers.
CK_DB1 and CK_DB2 have an important database that is mirrored. CK_DB3 is a helper and
CK_DB1 is considered the principle database. You then implement a patch that requires CK_DB1
and CK_DB2 to be rebooted. However since the patching was done as quickly as possible the
database that was online at the time could not use the patch. This database cannot use the patch
present which result in that the database does not failover to the other partner.
What should you have done?
A.
You should consider using the patch to the server that implements CK_DB1 before using the
patch to the server that implements CK_DB2.
B.
You should consider using the patch to the server that implements CK_DB3 before using the
patch to the server that implements CK_DB1.
C.
You should consider using the patch to the server that implements CK_DB2 before using the
patch to the server that implements CK_DB1.
D.
You should consider stopping the mirroring session, use the patch to the server that
implements CK_DB2 and resume the mirroring session.