Interview Questions
1. How does Database Mirroring works?
In database mirroring, the transaction log records for a database are directly transferred from one server to another, thereby
maintaining a hot standby server. As the principal server writes the database’s log buffer to disk, it simultaneously sends that
block of log records to the mirror instance. The mirror server continuously applies the log records to its copy of the database.
Mirroring is implemented on a per-database basis, and the scope of protection that it provides is restricted to a single-user
database. Database mirroring works only with databases that use the full recovery model.
Submit an interview question
Submitted questions and answers are subject to review and editing, and may or may not be selected for posting, at the sole discretion of w3Sniff.
Get Started
Comments
Leave a Comment