Andrew

Now back after a quick Xmas break! This is one thing that we've been asked to - it's now on my ever growing "things to do list".

Cheers

Chris



>G'day Chris,
>
>Have you considered archiving to tables rather than text files? Much easier to query and restore.
>
>One way to do it is to SELECT INTO the new table all the records you want to keep real-time access to, then take the (complete) old table off line.
>
>The start of the Sydney-Horbart sounds nice. I'm going to be at the MCG on boxing day.
>
>All the best for the Festive Season.
>
>Cheers,
>
>Andrew
>
>>Andrew
>>
>>We already archive information by taking it from the active table and dumping it into a text file so that it can be retrieved later - but this was tooooo complicated to restore it, and report on it, hence the need to store more. Splitting the table is a good idea - something that I can work on...
>>
>>As far as the WI are concerned - I'd bet on a 5-0 result more than changing this stuff to SQL...perhaps they should get Sir Viv back on board - at least he got SOME runs this afternoon. Lets hoping Sydney puts on some good weather for the Syd-Hobart as we'll actually be in Sydernee to watch!
>>
>>Thanks again
>>
>>Cheers
>>
>>Chris