Re: [GENERAL] Backing up and deleting a database.

2008-07-15 Thread Charles Duffy
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 unlikley

Re: [GENERAL] Backing up and deleting a database.

2008-07-15 Thread Bill Moran
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 again.

[GENERAL] Backing up and deleting a database.

2008-07-14 Thread Andrew Maclean
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