CodeGuru Home VC++ / MFC / C++ .NET / C# Visual Basic VB Forums Developer.com
Results 1 to 3 of 3
  1. #1
    Join Date
    Jun 2004
    Location
    New Jersey, USA
    Posts
    341

    Archiving MS SQL DB

    I am trying to write a script that will allow me to do DB archiving. I want to archive all records in tables that are for example 1 year old or older. However I still want to have an ability to search these archived records manually when I need to but have all programs using DB only go though current DB.

    Is there any standards I should follow for archiving, or does MS SQL has some utilities do that. This is the first time I am doing this so I was wondering if anybody had an experience with it and can point to some strands and tip I need to encounter. So far I am just planning on creating scrip with transactionsthat will copy old record to Archive DB and will delete it from the current DB

    Thank you for any suggestions!!!
    "We act as though comfort and luxury were the chief requirements of
    life, when all that we need to make us happy is something to be
    enthusiastic about."

    - Einstein

  2. #2
    Join Date
    Apr 2001
    Location
    Tampa Florida
    Posts
    233

    Re: Archiving MS SQL DB

    Hello
    I dont know about standards
    but it is easy enough to assign a time stamp on each new entry
    and to write the where search clause to only include those current to the last year.
    You can use COleDateTime (COleTimeDate?) to easily compare todays date to the stamp
    Regards
    "trampling out the vintage"

  3. #3
    Join Date
    Jun 2004
    Location
    New Jersey, USA
    Posts
    341

    Re: Archiving MS SQL DB

    Thanks for reply,

    I am wokring on the application taht alrwady has 10000 of records, stored procedures so it not an option to change selection in where clause. The only option is to actually archive old part of DB
    "We act as though comfort and luxury were the chief requirements of
    life, when all that we need to make us happy is something to be
    enthusiastic about."

    - Einstein

Posting Permissions

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





Click Here to Expand Forum to Full Width

Featured