You work as a database administrator at ABC.com.ABC.com makes use of SQL Server 2008 R2.
ABC.com has three database servers, named ABC-SR13, ABC-SR14, and ABC-SR15, which are
each running a different instance of SQL Server 2008. You have configured a database mirroring
session in high-safety mode between ABC-SR13 and ABC-SR14 for an important ABC.com
database. ABC-SR13 is presently configured as the principal server, while ABC-SR14 is
configured as the mirror server. ABC-SR15 is configured as the witness server.
Which of the following is TRUE with regards to database mirroring? (Choose all that apply.)
A.
You are able to mirror any database.
B.
Mirroring of the master, msdb, tempdb, or model databases is not supported.
C.
Database mirroring is not supported by the simple and bulk-logged recovery models.
D.
The full, simple, and bulk-logged recovery models support database mirroring.
Explanation: