Dear all,
I'm a "newbie" on SQL2005 mirroring and I need some help.
I'm going to set up a db mirroring with high availability, I mean with
principal-mirror-witness scenario.

I know that if the principal goes down, the mirror automatically take its
place. But at this point, is the DB in read only mode ?? Or is any
WRITE/modification allowed ??

Thanks in advance!
Luca

Good question.

The mirror automatically takes over all the functionality of the principal,
including read-write transaction processing during a failure event.

Everything keeps running.

--
Geoff N. Hiten
Principal SQL Infrastructure Consultant
Microsoft SQL Server MVP




"Luca" <Luca (AT) discussions (DOT) microsoft.com> wrote

Thanks Geoff, I'm doing some tests on a lab environment!

Regards,
Luca

"Geoff N. Hiten" wrote:

That is the best way to learn about actual system behavior.

---GNH


"Luca" <Luca (AT) discussions (DOT) microsoft.com> wrote