Archiving

  • Hi All

    I need help with archiving data on one of the tables in Production (IAS), The table has over 69mil records, so i need to keep data up to 3 months for reporting but i dont want to delete it and the tricky part it's also a replicated enviroment.

    Any solution is welcomed!!

    Thx

    Jnr DBA

    It's better to fail while trying, rather than fail without trying!!!

  • Can you create an Archive database (or table), move the data there, delete it from the main database, and then the reports that might need the old data can use a Union All operator to query from both tables at the same time?

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

  • Hi

    I agree with GSquared answer, coz this way you can save data and from performance point of view also it is good. But curious to know do you have partitions on this table?

    Thanks -- Vj

    http://dotnetvj.blogspot.com

  • Hi

    No partition on the table

    Thx

    It's better to fail while trying, rather than fail without trying!!!

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply