t_j_haynes wrote:

>Thanks for all the suggestions everyone. My thinking on these is as
>follows..
>
>There are generic database replication tools. These tend to work by
>polling and comparing tables. This is quite performance intensive,
>especially if the replica is to be kept reasonably up to date.
>
>Similarly, continually taking small incremental backups sounds a bit
>fiddly and performance intensive. Also rather a slow recovery,
>reassembling all the incremental backups.
>
>

Tim,

You could restore the database to an especific hour for example with a
set of 3 levels of backup's
1.) For the weekly (a whole back-up)
2.) for the day (the difference between the day and the start of the week)
3.) for the hour (the difference between the current hour to the start
of the day)

maybe it's not too expensive....

see you !

--

Alexandre Benson Smith
Development
THOR Software e Comercial Ltda.
Santo Andre - Sao Paulo - Brazil
www.thorsoftware.com.br



--
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.323 / Virus Database: 267.7.9/23 - Release Date: 20/06/2005