RE: Re: [WAY OT] - SQL Replication

["Young, Jeff" <Jeff.Young@xxxxxxxx>]

Hi Chris

Can I ask which SAN disk arrays you are using ?

-----Original Message-----
From: Chris Bond [mailto:chrisbonduk@xxxxxxx]
Sent: 29 November 2004 16:45
To: ukha_d@xxxxxxx
Subject: [ukha_d] Re: [WAY OT] - SQL Replication




--- In ukha_d@xxxxxxx, neil_frost@g... wrote:
> 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....

Erk - don't use SQL Replication it sucks! - SQL 2005 introduces it
in a completly different way but it wont be out till summer05.

> 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....

We use a SAN here and use the SAN's replication MirrorView software,
works at Disk IO level rather than database level.  You possible
want to look into using microsoft sql clustering instead of using
sql replication.





--------------------------------------------------------------------------------
The information contained herein is confidential and is intended solely for
the
addressee. Access by any other party is unauthorised without the express
written permission of the sender. If you are not the intended recipient,
please
contact the sender either via the company switchboard on +44 (0)20 7623
8000, or
via e-mail return. If you have received this e-mail in error or wish to
read our
e-mail disclaimer statement and monitoring policy, please refer to
http://www.drkw.com/disc/email/
or contact the sender. 3166
--------------------------------------------------------------------------------