[Message Prev][Message
Next][Thread Prev][Thread Next][Message
Index][Thread Index]
Re: [WAY OT] - SQL Replication
- Subject: Re: [WAY OT] - SQL Replication
- From: "Chris Bond" <chrisbonduk@xxxxxxxxx>
- Date: Tue, 30 Nov 2004 15:47:28 -0000
--- In ukha_d@xxxxxxx, "Alex Monaghan" <ha@m...> wrote:
> We use log shipping for keeping database in sync for reporting &
DR
> failover.
>
> If you have SQL 2K Enterprise, then you'll have a wizard to set it
up
> (although I use my own set of scripts), if you have standard, then
you'll
> have to get your DBA to roll their own config.
>
> I've been using a log shipping mechanism since SQL 6.5 for DR
purposes and
> routinely perform failovers and have had no problem so far.
All depends on the database size and rate of change per day really
but i'd have to agree with alex, its a good way of doing things if
the rate of change isnt that bad.
UKHA_D Main Index |
UKHA_D Thread Index |
UKHA_D Home |
Archives Home
|