Re: [WAY OT] - SQL Replication

["Chris Bond" <chrisbonduk@xxxxxxxxx>]

Dell/EMC CX500 =)

--- In ukha_d@xxxxxxx, "Young, Jeff" <Jeff.Young@D...>
wrote:
> Hi Chris
>
> Can I ask which SAN disk arrays you are using ?
>
> -----Original Message-----
> From: Chris Bond [mailto:chrisbonduk@g...]
> 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
> -------------------------------------------------------------------
-------------