-
June 19th, 2006, 09:59 AM
#1
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
-
June 21st, 2006, 02:30 PM
#2
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"
-
June 21st, 2006, 03:26 PM
#3
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|