Re: Log Shipping or Replication
From: Gabe Matteson (gmatteson_at_inquery.biz.nospam)
Date: 11/02/05
- Next message: John: "DSN Configuration setting "Use strong encryption for data""
- Previous message: Dejan Sarka: "Re: GRANT SELECT for all tables"
- Maybe in reply to: Gabe Matteson: "Log Shipping or Replication"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Date: Wed, 2 Nov 2005 16:37:22 -0500
Thanks, I appreciate all the replies!
"Chris Shaw" <Chris_Shaw@SQLPASS.org> wrote in message
news:82847E0A-0820-40A4-B07F-130200E5E231@microsoft.com...
> Gabe,
>
> All the answers you have recieved are good ones. Let me see if I can add
> some added information.
>
> Replication for a fail over option can work. I personally would not
> recommend it unless your database is designed for Merge Replication.
> Merge
> replication would give you the ability to start writing to another server
> as
> soon as the failover conncetion is made.
>
> Log Shipping has a time delay on the time the data is moved from the
> production server to the standby server. This is going to depend on your
> t-log backup schedule.
>
> IMHO I would consider looking at less expensive failover options. I use
> both Active/Active and Active/Passive. I perfer A/A becuase the second
> piece
> of hardware is not sitting there doing nothing when the primary node is
> up.
> The other option that I think you need to look at no matter what soultion
> you
> choose is does the application understand the database failover. If a
> conncetion is broken do you have to re-connect manually, or will the app
> look
> for the second server after a certian amount of time without a responce.
> If
> you are at a company where they mention that they can not afford to be
> down
> or they are losing money. Then I would let them know that they really
> can't
> afford to be without a cluster. I know that CDW sells them in a package
> for
> pretty cheap. I have a contact that if you would like send me a note and
> I
> am sure she could get you a good quote.
>
> If you would like more infomation about the 3 options please let us know.
> I
> am sure that you will get a ton of answers.
>
> --Chris
>
> If you wou
>
> "Gabe Matteson" wrote:
>
>> Which would you recommend to setup as a failover database server? (We do
>> not
>> have the ability right now to setup a sql cluster). What is the
>> difference
>> between log shipping and database replication? Pros/Cons? Thanks.
>> - Gabe
>>
>>
>>
- Next message: John: "DSN Configuration setting "Use strong encryption for data""
- Previous message: Dejan Sarka: "Re: GRANT SELECT for all tables"
- Maybe in reply to: Gabe Matteson: "Log Shipping or Replication"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
