motioneye
asked on
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 ?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Automatic page repair with database mirroring is available in Enterprise Edition of SQL Server 2008/2008R2.
ASKER
How about sql2005, do we have similar option ? any link from Mcsft to reconfirm ?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
hi
Automatic page repair is available is avalilable starting sql server 2008.
and not available before.
Automatic page repair is available is avalilable starting sql server 2008.
and not available before.
ASKER
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 ?
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 ?
yes once the Principal database isent accessible failover occurs
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.