• The somewhat contradictory MS documentation is a bit of a mess. Anyway, it seems clear that if you lose File 1 page 9 in a mirrored database you can't even recover that page from the mirror http://msdn.microsoft.com/en-us/library/bb677167.aspx using the built-in recovery mechanism included in mirroring, no can you recover it by any other shortcut means - your database is dead until full recovery is done by one means or another (effectively blowing the whoe database away and recovering it from backups or with snapshot replication from a working copy or some equivalent equivalent mechanism) - at least I'm not aware of any means of recovering that page from the log file, so even though it appears that there is a copy in the log file it doesn't seem to be very useful (I suppose you might be able to do something with a physical level disc editor, but that's way outside the scope of SQL).

    Tom