We have one table that is three times as large as the rest of the database.
Most of the data is static after approximately 3-6 months, but we are
required to keep it for 8 years. I would like to archive this table (A), but
there are complications.
1. the only way to access the data is through the application (they are
images produced by the application-built on Power-Builder)
2. there are multiple tables refrencing this table and vise-versa
3. we restore the entire db to two other servers for testing and training
regularly
4. there might be more complications that have not been thought of
Currently, our only plan is to setup a seperate server with a copy of this db
on it and the application. Leave only the tables necessary to access the data,
and if this 'archive' works, remove from production the data from the table A
and all references to the table A from rows on the other tables.
I mentioned #3 because someone mentioned a third party tool that may be able
to pull the data from the table, archive it elsewhere, and at the same time,
place a 'pointer' in the table to the new storage location. The tool they
mentioned only works on Oracle and we have not explored beyond that yet.
I am ready to explore ideas and suggestions; I am still new to the DBA world,
I am out of ideas.
Thank you!
--
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forum...eneral/200607/1On Thu, 20 Jul 2006 14:23:50 GMT, iamset via SQLMonster.com wrote:
(snip)
Quote:
Originally Posted by
>I am ready to explore ideas and suggestions; I am still new to the DBA world,
>I am out of ideas.
Hi iamset,
You might wish to explore distributed partitioned views. Looks like
they're the exact right tool for this job.
Books Online has good information on them.
--
Hugo Kornelis, SQL Server MVP
No comments:
Post a Comment