I have a mirror setup, and I want to test failover recovery when things go bad.
Like in clustering, I can probably disable a NIC and simulate failover. For example, we loosing a Principal server, its gone, and I want to bring my mirror online. I would alter database <dbname> set partner force_service_allow_data_loss.
Is that possible? let say I reboot the principal server and it doesn't come back, how do I bring my mirror back online? If it's setup in a mirroring session, I can't use the alter above because it is part of a mirroring session.
What about testing when a corruption occurs.
I am looking for scenarios laid out that show me how to create problems and recovery from them for database mirroring.