Post reply

Archieve Table

  • April 21, 2008 at 11:56 pm

    #189583

    Hi Experts

    What is Archieve Table ?

    How can we maintain Archieve table in sql server could please give guidence.

    Regards

    ms

  • April 22, 2008 at 4:31 am

    #805390

    I think you mean Archive Tables.

    These are tables where you can transfer data to that is not immidiately required.

    Say you have a transaction table where you insert several thousands of records each day. If you don't transfer data to an Archive Table, the transaction table will become very large and performance will drop. By periodically moving data (use job agent) from the transaction table to an archive table you keep the transaction table at such a size that has good performance/relevant data available. The application must be programmed to retrieve new data from the Transaction Table and older data from the Archive Table.

    Regards,

    Hans

    ** Don't mistake the ‘stupidity of the crowd’ for the ‘wisdom of the group’! **

  • April 24, 2008 at 7:00 am

    #806534

    I think finally DBAs will have to build a complete soulution for Archiving. nor Developers neither Analysts work on this problem..And we ( DBAs ) always force them to avoid decreasing performance , meaningless repeating backups..etc..

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

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