Every day for the next couple of weeks, I aim to highlight one of SQL Server 2008’s new features, simply for awareness. You can then go away and research the area and report back to me, we’ll then discuss how these new features can benefit us all.

Monday 17th May 2010

Automatic Recovery of Data Pages

The boffs at Microsoft continue to make their high availability solutions as painless as possible. 

In mirroring, the principal and mirror machines ar enow able to transparently recover from 823/824 types of data page errors. This is achieved by requesting a fresh copy of the suspect page from the mirroring partner – all transparent to end users and applications.