We help IT Professionals succeed at work.

Check out our new AWS podcast with Certified Expert, Phil Phillips! Listen to "How to Execute a Seamless AWS Migration" on EE or on your favorite podcast platform. Listen Now

x

db mirroring with automatic failover

motioneye
motioneye asked
on
Medium Priority
642 Views
Last Modified: 2012-06-21
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 ?
Comment
Watch Question

Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION
Daniel_PLDB Expert/Architect
Top Expert 2011

Commented:
Automatic page repair with database mirroring is available in Enterprise Edition of SQL Server 2008/2008R2.

Author

Commented:
How about sql2005, do we have similar option ? any link from Mcsft to reconfirm ?
Daniel_PLDB Expert/Architect
Top Expert 2011
Commented:
Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION
Aaron ShiloChief Database Architect
CERTIFIED EXPERT

Commented:
hi

Automatic page repair is available is avalilable starting sql server 2008.
and not available before.

Author

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 ?
Aaron ShiloChief Database Architect
CERTIFIED EXPERT

Commented:
yes once the Principal database isent accessible failover occurs
Daniel_PLDB Expert/Architect
Top Expert 2011
Commented:
Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a sample view!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.