In response to "Andrew Maclean" <[EMAIL PROTECTED]>:
> We have a database that grows in size quite quickly. Of course we
> backup nightly and keep a weeks worth of data
>
> However we need to keep a few months data online, but the rest can be
> archived as it will be unlikley that it will be used
Hi,
On Tue, Jul 15, 2008 at 2:52 PM, Andrew Maclean
<[EMAIL PROTECTED]> wrote:
> We have a database that grows in size quite quickly. Of course we
> backup nightly and keep a weeks worth of data
>
> However we need to keep a few months data online, but the rest can be
> archived as it will be unli
We have a database that grows in size quite quickly. Of course we
backup nightly and keep a weeks worth of data
However we need to keep a few months data online, but the rest can be
archived as it will be unlikley that it will be used again.
As I see it we can:
1) Run a query to drop/delete old d
