SQL2005 Mirroring

Giganews Newsgroups
Subject: SQL2005 Mirroring
Posted by:  Pierluigi (Pierlui…@discussions.microsoft.com)
Date: Mon, 14 May 2007

Hi everybody.
I have been evaluating this feature in order to fail-over between two server
in two remote site connected through a 1 Gbps link.

Anybody had good experience about it?

Can I mirror a SQL2005 Enterpise Itanium Edition with a SQL2005 Enterprise
on a 32-bit system ?

Can I do some Kind of fail-over between the primary and the secondary
without the witness ?

Can I use a PC with Windows2000/XP and SQL2005 Express as witness ?

Do I have some prerequisite on the SQL2005 client in order to use fail-over?

Thank you in advance.

Pierluigi

Replies