Archive old documents from a production database.
Posted on 2004-09-21
Hello all experts,
Let me briefly explain what I have here.
I have a production database on a server which contains documents ranging from year 2001 to 2004 and more.
What I need to do now is archive the documents that are not of the current year(2004) into another database(archive_year.nsf) and delete the archived documents from the production database.
I am not the server administrator.
Can somebody please tell me what would the server administrator need to do for this archiving? Will he need to create a new empty database then have someone code an agent to run on the production server that will select the documents and copy it to the new database?
Or are there some other steps? I need detailed step-by-step instructions if possible as I need to do a documentation on this. Thanks for the help and let me know if more details are needed.