[Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 590
  • Last Modified:

db mirroring with automatic failover

I have one concern with db mirroring on automatic failover, if for some reasons our database corrupted, having suspect pages or any reasons which caused db corrupted, will this trigger mirror db to be online as principal ? and will the principal  mirror the suspect pages, corrupted msgs to mirror db ?
0
motioneye
Asked:
motioneye
  • 3
  • 2
  • 2
  • +1
3 Solutions
 
Umesh_MadapCommented:

if a page becomes corrupt on the principal, SQL Server should be able to read the page from the mirror and
use it to fix the principal. Similarly, if a page becomes corrupt on the mirror, the page can be read from the
principal to fix up the mirror.  
0
 
Daniel_PLDB Expert/ArchitectCommented:
Automatic page repair with database mirroring is available in Enterprise Edition of SQL Server 2008/2008R2.
0
 
motioneyeAuthor Commented:
How about sql2005, do we have similar option ? any link from Mcsft to reconfirm ?
0
Visualize your virtual and backup environments

Create well-organized and polished visualizations of your virtual and backup environments when planning VMware vSphere, Microsoft Hyper-V or Veeam deployments. It helps you to gain better visibility and valuable business insights.

 
Daniel_PLDB Expert/ArchitectCommented:
Automatic page repair is available also in Standard edition of SQL Server 2008.
(Automatic Page Repair During a Database Mirroring Session see changelog)
Whole feature of automatically repairing corrupted pages is available only from SQL Server 2008 version.
0
 
Aaron ShiloCommented:
hi

Automatic page repair is available is avalilable starting sql server 2008.
and not available before.
0
 
motioneyeAuthor Commented:
Ok,
so when this principal db get corrupted, what should be status in mirror db ? for example db in principal appear with suspect mode ? will failover occur and db in mirror become online without getting suspect ?
0
 
Aaron ShiloCommented:
yes once the Principal database isent accessible failover occurs
0
 
Daniel_PLDB Expert/ArchitectCommented:
Automatic failover is available only in high-safety mode with witness. When only some pages become corrupted they will be copied to mirror server.
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 3
  • 2
  • 2
  • +1
Tackle projects and never again get stuck behind a technical roadblock.
Join Now