The UK Home Automation Archive

Archive Home

Group Home

Search Archive
Advanced Search

The UKHA-ARCHIVE IS CEASING OPERATIONS 31 DEC 2024

[Message Prev][Message Next][Thread Prev][Thread Next][Message Index][Thread Index]

[WAY OT] - SQL Replication

Subject: [WAY OT] - SQL Replication
From: neil_frost@xxxxxxxxxxxxxxxxx
Date: Mon, 29 Nov 2004 16:39:39 +0000


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]

Follow-Ups:
- Re: [WAY OT] - SQL Replication
  - From: Ben McCormack

Prev by Message: [OT] EFH broadband- verdict?
Next by Message: Re: [WAY OT] - SQL Replication
Previous by thread: RE: [ukha_d] <�400 tablet PC
Next by thread: Re: [WAY OT] - SQL Replication
Index(es):
- Message
- Thread

UKHA_D Main Index | UKHA_D Thread Index | UKHA_D Home | Archives Home

Comments to the Webmaster are always welcomed, please use this contact form . Note that as this site is a mailing list archive, the Webmaster has no control over the contents of the messages. Comments about message content should be directed to the relevant mailing list.