Re: wanted : archive tool
Date: Thu, 29 Jan 2004 15:18:57 GMT
Message-ID: <Bv9Sb.50285$U%5.271410_at_attbi_s03>
<fhoornaert_at_hotmail.com> wrote in message
news:9ce3481b.0401290647.4a005655_at_posting.google.com...
> Hello,
>
> I'm looking for a reliable software solution for archiving a production
> database to a backup database.
>
> the main goal of the archiving tool :
> Without archiving, the production database would have a total of
100Gb/year
> over 300 tables.
> The customer only wants the data of the last 3 months in the production
> database so that it can be easily backup each night.
> Data older then 3 months should be transferred once a month to an archive
> database.
> This archive database should have the same structure as the production
> database and should also be on-line 24h a days.
> Data in the archived database should be kept for 30 years.
>
> We have a lot of administration tables (250 out of 300) which are only
> updated, no records are added. The other 50 tables (used for
registrations)
> have lots of inserts in them.
> The administration tables should be synchronized from the production DB to
> the archive DB, while the registration tables should be transferred based
on
> a date.
>
> Which are the possibities ? Any good 3rd party solutions ? And without 3rd
> party solution ?
>
> When replying, please CC to my email account
> --
> Greetz,
> Frederic Hoornaert
You could use partitions to partition the data. Your biggest problem will be keeping the schema stable for 30 years. Jim Received on Thu Jan 29 2004 - 16:18:57 CET