Multiple choice technology databases

Wchich recovery model should database be in for database mirroring to be configured on it

  1. Bulk logged

  2. Half

  3. Full

  4. Simple
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

Database mirroring requires the FULL recovery model because it needs to maintain a complete transaction log to ship log records from the principal to the mirror server. The Simple recovery model truncates the log automatically, preventing log shipping. Bulk-logged recovery also has limitations that make it unsuitable for mirroring. 'Half' is not a valid recovery model in SQL Server.

Keep practicing — related questions