Friday, March 30, 2012

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,

No comments:

Post a Comment