Principles of automatic page repair for SQL Server database mirroring

Principles of automatic page repair for SQL Server database mirroring

Damaged Main Library page

Image Library page corruption

LSN is used to guarantee the timing of transactions

LSN is saved in the data page header, the LDF file of the main library, and the LDF file of the image Library, then the three of them set up a bridge of communication.

We've got a comparison of LSN to see if everyone's data is consistent.

In the field of distributed databases, it is also necessary to ensure the timing of transactions, but also through LSN some databases such as Oracle with the SCN to ensure the timing of each distribution database, to ensure that the data of each database consistent

In fact, whether it is distributed or non-distributed areas are the same, the distributed field is not too many tall things, are the same to ensure that the data consistent, are through the LSN or something like LSN to build bridges

If there is a wrong place, welcome everyone to shoot brick O (∩_∩) o

Principles of automatic page repair for SQL Server database mirroring