Wednesday, March 7, 2012

DB Mirroring?

Any word on when DB Mirroring will be released?I believe it is currently scheduled for a mid-2006 supported release.
In the meantime, you can start MSSQL with trace flag 1400 to enable the
non-supported db mirroring.
Cheers
Rob|||Mirroring IS released. It is in the product and can be used. It is not
supported at this point, which is different from being released. You have
to turn on trace flag 1400 on all instances participating in mirroring, but
it can be done.
It will be supported when they are ready to support it, there aren't any
dates published. It does work and it will work very reliably and very
effectively. I've been testing it since Beta 1 and have deployed it into
production at 3 customers already as well as working with several other
companies to define their architecture around Mirroring. I have zero qualms
with putting it into poduction at this point, even if it isn't supported
yet.
--
Mike
Mentor
Solid Quality Learning
http://www.solidqualitylearning.com
"Joe D" <jkdriscoll@.qg.com> wrote in message
news:douttr$8ej$1@.sxnews1.qg.com...
> Any word on when DB Mirroring will be released?
>|||Mike,
Thanks for the reply. I have a follow up question about DB Mirroring. I
attended a one day event in Chicago several months back and was impressed
with DB Mirroring. What I don't remember though is, how does DB Mirroring
differ from Replication? Is there a good source (white paper, blog) that
describes the differences, the Pro's & Con's of both?
thanks,
Joe D
"Michael Hotek" <mike@.solidqualitylearning.com> wrote in message
news:u44db2NDGHA.516@.TK2MSFTNGP15.phx.gbl...
> Mirroring IS released. It is in the product and can be used. It is not
> supported at this point, which is different from being released. You have
> to turn on trace flag 1400 on all instances participating in mirroring,
> but it can be done.
> It will be supported when they are ready to support it, there aren't any
> dates published. It does work and it will work very reliably and very
> effectively. I've been testing it since Beta 1 and have deployed it into
> production at 3 customers already as well as working with several other
> companies to define their architecture around Mirroring. I have zero
> qualms with putting it into poduction at this point, even if it isn't
> supported yet.
> --
> Mike
> Mentor
> Solid Quality Learning
> http://www.solidqualitylearning.com
>
> "Joe D" <jkdriscoll@.qg.com> wrote in message
> news:douttr$8ej$1@.sxnews1.qg.com...
>> Any word on when DB Mirroring will be released?
>|||This is the most comprehensive whitepaper on Database Mirroring that exists.
http://www.microsoft.com/technet/prodtechnol/sql/2005/dbmirror.mspx
There isn't an equivalent for replication. The main part is with the
integration point within the engine. Mirroring operates at an engine level
and writes transactions to the mirror as they occur. Replication happens
external to the engine and duplicates transactions after they have already
been committed.
--
Mike
Mentor
Solid Quality Learning
http://www.solidqualitylearning.com
"Joe D" <jkdriscoll@.qg.com> wrote in message
news:dp3s5r$g02$1@.sxnews1.qg.com...
> Mike,
> Thanks for the reply. I have a follow up question about DB Mirroring. I
> attended a one day event in Chicago several months back and was impressed
> with DB Mirroring. What I don't remember though is, how does DB Mirroring
> differ from Replication? Is there a good source (white paper, blog) that
> describes the differences, the Pro's & Con's of both?
> thanks,
> Joe D
>
> "Michael Hotek" <mike@.solidqualitylearning.com> wrote in message
> news:u44db2NDGHA.516@.TK2MSFTNGP15.phx.gbl...
>> Mirroring IS released. It is in the product and can be used. It is not
>> supported at this point, which is different from being released. You
>> have to turn on trace flag 1400 on all instances participating in
>> mirroring, but it can be done.
>> It will be supported when they are ready to support it, there aren't any
>> dates published. It does work and it will work very reliably and very
>> effectively. I've been testing it since Beta 1 and have deployed it into
>> production at 3 customers already as well as working with several other
>> companies to define their architecture around Mirroring. I have zero
>> qualms with putting it into poduction at this point, even if it isn't
>> supported yet.
>> --
>> Mike
>> Mentor
>> Solid Quality Learning
>> http://www.solidqualitylearning.com
>>
>> "Joe D" <jkdriscoll@.qg.com> wrote in message
>> news:douttr$8ej$1@.sxnews1.qg.com...
>> Any word on when DB Mirroring will be released?
>>
>

No comments:

Post a Comment