|
Home > Archive > MS SQL Server Replication > January 2006 > sql data redundancy
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
sql data redundancy
|
|
|
| hi, all
Sql data mirriring.
There is any sql server drives mirriring. means that not only hardware
redundency but the sql data redundancy. When users updating through front
end apps, it updates the both mirriring drives.
Is that true?
Thanks
| |
| Michael Hotek 2006-01-17, 8:23 pm |
| There is mirroring at a disk level and then there is database mirroring
within SQL Server 2005. They are very different technologies.
When you implement mirroring (RAID technologies), the application simply
writes changes and the RAID controller handles the mirror operations on the
backend.
When you implement database mirroring, transactions are sent to the mirror
server as they are flushed from dirty buffers to the transaction log.
In either case, the mirroring operation is completely transparent to your
applications.
--
Mike
http://www. solidqualitylearning
.com
Disclaimer: This communication is an original work and represents my sole
views on the subject. It does not represent the views of any other person
or entity either by inference or direct reference.
"mecn" <mecn2002@yahoo.com> wrote in message
news:uodZm%233GGHA.532@TK2MSFTNGP15.phx.gbl...
> hi, all
>
> Sql data mirriring.
>
> There is any sql server drives mirriring. means that not only hardware
> redundency but the sql data redundancy. When users updating through front
> end apps, it updates the both mirriring drives.
> Is that true?
> Thanks
>
| |
|
| Thanks,
which one you think is more effcient for sql2005 server?
"Michael Hotek" < mike@solidqualitylea
rning.com> wrote in message
news:ua3bzQ6GGHA.2696@TK2MSFTNGP14.phx.gbl...
> There is mirroring at a disk level and then there is database mirroring
> within SQL Server 2005. They are very different technologies.
>
> When you implement mirroring (RAID technologies), the application simply
> writes changes and the RAID controller handles the mirror operations on
> the backend.
>
> When you implement database mirroring, transactions are sent to the mirror
> server as they are flushed from dirty buffers to the transaction log.
>
> In either case, the mirroring operation is completely transparent to your
> applications.
>
> --
> Mike
> http://www. solidqualitylearning
.com
> Disclaimer: This communication is an original work and represents my sole
> views on the subject. It does not represent the views of any other person
> or entity either by inference or direct reference.
>
> "mecn" <mecn2002@yahoo.com> wrote in message
> news:uodZm%233GGHA.532@TK2MSFTNGP15.phx.gbl...
>
>
| |
| Michael Hotek 2006-01-23, 9:23 am |
| Which one tastes better an orange or a pear?
The technologies do completely different things and interact with the system
at completely different levels. There isn't any basis to compare them on.
--
Mike
http://www. solidqualitylearning
.com
Disclaimer: This communication is an original work and represents my sole
views on the subject. It does not represent the views of any other person
or entity either by inference or direct reference.
"mecn" <mecn2002@yahoo.com> wrote in message
news:%238lZAz6GGHA.3120@TK2MSFTNGP10.phx.gbl...
> Thanks,
> which one you think is more effcient for sql2005 server?
>
>
>
> "Michael Hotek" < mike@solidqualitylea
rning.com> wrote in message
> news:ua3bzQ6GGHA.2696@TK2MSFTNGP14.phx.gbl...
>
>
|
|
|
|
|