Monday, March 12, 2012

high availability questions

Hello:
I just need help with one more thing tonight. I want to thank you all that
have helped me tonight with other questions.
I have a few short questions about high availability.
Is the process of log shipping just about restoring transaction logs?
Is transactional replication mostly just good for read-only data, while
snapshot replication is better in terms of restoring write data?
I know that snapshots good are for providing users with data that they need
from a previous "snapshot" of the system. And, I know that mirroring is
strictly a high availability procedure. So, with regard to snapshotting, my
guess is that mirroring is "better" than snapshotting. Is that right?
Thanks, again, to all of you! God bless you!
childofthe1980sMirroring is meant for high availability. While a snapshot could be used to
get you out of a jam, the data will only be as current as when the snapshot
was taken (if Im not mistaken, if created some snapshots, but not done a
restore). If you look in BOL under "high availability [SQL Server]", you
will see that snapshotting is not even listed. Log shipping is good, but I
think MS is trying to get people into Mirroring. Replication, in my opinion,
is not a valid high availability solution for many reasons. Many will
disagree with me on that one, but thats my take.
"childofthe1980s" <childofthe1980s@.discussions.microsoft.com> wrote in
message news:7E4D8463-4F59-4DAD-B5A2-E8B92C1F043D@.microsoft.com...
> Hello:
> I just need help with one more thing tonight. I want to thank you all
that
> have helped me tonight with other questions.
> I have a few short questions about high availability.
> Is the process of log shipping just about restoring transaction logs?
> Is transactional replication mostly just good for read-only data, while
> snapshot replication is better in terms of restoring write data?
> I know that snapshots good are for providing users with data that they
need
> from a previous "snapshot" of the system. And, I know that mirroring is
> strictly a high availability procedure. So, with regard to snapshotting,
my
> guess is that mirroring is "better" than snapshotting. Is that right?
> Thanks, again, to all of you! God bless you!
> childofthe1980s
>

No comments:

Post a Comment