Post reply

What is Archiving Database how it will be

  • July 17, 2006 at 3:41 am

    #61671

    Hi

    What is the archiving Database,how it will be

    some body told that you do arching when it is behind the mainteenace size

    some body give clear idea abt ACHIVING DATABASE

  • July 17, 2006 at 6:20 am

    #649498

    Hi,

    Not 100% sure what your question is.  If you are asking what is archiving, then put it simply, it is moving data from a table/database to another table/database.

    For example, you may have a order/sales table going back 10 years.  You may only need to keep 3 years active, but the business may want to hold historic data.  You could create an archive table and move any data older than 3 years into the archive table.

    This way, query performance will be boosted by a reduced number of records.  However, if this is the case, stored procedures, queries etc will need to me modified (or new ones added) to read in historic data.

    With regards to maintenance then it goes 2 ways.  If you have the archive tables in the same database, then you won't gain a whole lot as you'll still need to maintain the same amount of data.  If you had an archive database, then you could have 2 seperate maintenance plans (one for the production database and one for the archive database).

    Hope that helps.  If not feel free to post further questions.

  • July 17, 2006 at 7:46 am

    #649512

    When you design a database, always think whether you might need an archive database or not.

    If your database will store data for a long time, and if that data can take up a lot of space, it is usually a good idea to copy it to a separate, "Archive" database. Try not to let your "live" database grow for ever, getting bigger and bigger.

    Having a separate database will allow you to add indexes that make queries run more quickly on the large tables. If you allow your "live" database to grow instead, and put the same indexes on the tables, then you will slow down your data input speed.

    Sometimes, you will not be able to make use of an archive database, but it is usually a good idea to try.

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

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