Explanation:Mirroring works only with databases that use the full recovery model. 3. Which of the following benefit is provided by database mirroring ?
A. Increases data protection.
B. Improves the availability of the production database
C. Increases availability of a database.
D. All of the mentioned
Answer:A
Explanation:Mirroring works only with databases that use the full recovery model. 3. Which of the following benefit is provided by database mirroring ?
A. Increases data protection. B. Improves the availability of the production database C. Increases availability of a database. D. All of the mentioned
Explanation:To minimize downtime for a mirrored database, you can sequentially upgrade the instances of SQL Server that are hosting the failover partners. 4. Database mirroring operates in how many modes ?