Archive old data

Results 1 to 2 of 2

Thread: Archive old data

  1. #1
    Join Date
    Dec 1969

    Default Archive old data

    I have some sql 7 tables that are millions of rows, and most of the data isn&#039;t used anymore, however I need to keep the data and can not just delete it.<BR><BR>What is the prefered way to archive sql information?

  2. #2
    Join Date
    Dec 1969

    Default RE: Archive old data

    How do you determine what &#039;old data&#039; is? SQL does not automatically label a record as old or last used. You need to have somthing like a DTS (DateTimeSTamp) field which you can create using getdate().<BR><BR>Based on some business rules (whether the record is old), you can move the records to an archive table, backup the database and remove the archive table (if that&#039;s what you prefer, you could also just leave the archive table and add you new records to it periodically).<BR><BR>You need to think about the rules first.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts