Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2004

    Question Unanswered: How database mirroring can repair page corruptions?

    If we restore a database (full backup) first and continuously apply its transnational log backups, do we end up with two identical databases at page level eventually?

    If so, page level repair to principle server may work as documented. I can see SAN level mirroring will give you exactly two identical databases at page level eventually at some point of time.

    I can see Sybase device (in MS word file) level mirroring will give you two identical things at page level for same device.

    But applying the transcriptional logs sequentially on the other servers, can SQL Server guarantee these two databases are identical at page level given there is server configuration can be different?

  2. #2
    Join Date
    Feb 2004
    In front of the computer
    Provided Answers: 54

    In theory, theory and practice are identical. In practice, theory and practice are unrelated.

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts