RE: [WAY OT] - SQL Replication

["Alex Monaghan" <ha@xxxxxxxxxxxxxx>]

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.

> -----Original Message-----
> From: neil_frost@xxxxxxx [mailto:neil_frost@xxxxxxx]
> Sent: Monday, November 29, 2004 4:40 PM
> To: ukha_d@xxxxxxx
> Subject: [ukha_d] [WAY OT] - SQL Replication
>
>
> Sorry for the OT...
>
> I have a very large SQL 2000 database (70Gb) at work which needs
> reindexing every month (apparently - I'm not a SQL DBA I just run the
IT
> dept...)
>
> When the reindexing is done, it mucks up the replication and a new
> snapshot needs to be taken and the process started all over again.
> Apparently this is due to the way sql replicates at block level....
>
> Can anyone recommend a bit of software that would handle the
replication
> instead of SQL doing it as I don't want to have to restart the
replication
> every month....
>
> Thanks
>
> Neil
>
>
> [Non-text portions of this message have been removed]
>
>
>
>
>
>
> Yahoo! Groups Links
>
>
>
>
>
>