Mirroring different versions

I am looking into Mirroring versus Replication. When going over the SQL2005
version features it list Mirroring (Safety Full Only). Does this mean the
database has to be in Full Recovery mode or that the mirror has to be
synchronous?
Thanks,
It means yes to both. With other editions of SQL Server 2005 (ie Enterprise
Edition) you have other options for mirroring, ie High Performance.
http://www.zetainteractive.com - Shift Happens!
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Cindy" <Cindy@.discussions.microsoft.com> wrote in message
news:9CC6F9E4-41F0-4F7F-AC52-09E74ED88B9A@.microsoft.com...
>I am looking into Mirroring versus Replication. When going over the
>SQL2005
> version features it list Mirroring (Safety Full Only). Does this mean the
> database has to be in Full Recovery mode or that the mirror has to be
> synchronous?
> Thanks,

Mirroring - High Safety Mode

I'm testing DB mirroring in high safety mode without a witness server. When
I try to simulate a complete failure of the principal server (I stop the
principal SQL Server service) I can't get the mirrored DB's to come online.
The status is stuck in "mirror, disconnected/in recovery"
I don't have any errors in the event log other than an event ID 1474, SQL
communication error with the principal server.
Do I need a witness server ? CAN I GET A WITNESS ! ?
Nick
I added a witness server and this resolved my problem.
"Nick" <larosan@.yahoo.com> wrote in message
news:udadnef-_oVQGt3bnZ2dnUVZ_uKknZ2d@.comcast.com...
> I'm testing DB mirroring in high safety mode without a witness server.
> When I try to simulate a complete failure of the principal server (I stop
> the principal SQL Server service) I can't get the mirrored DB's to come
> online. The status is stuck in "mirror, disconnected/in recovery"
> I don't have any errors in the event log other than an event ID 1474, SQL
> communication error with the principal server.
> Do I need a witness server ? CAN I GET A WITNESS ! ?
> Nick
>
>
>
sql