Take the 2-minute tour ×
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It's 100% free, no registration required.

I have designed system where users submit Infopath forms to a Sharepoint 2007 site. The Infopath forms allow users to also attach pdfs in their submission.

My problem now is that the Sharepoint site is approaching their 20GB storage limit. So how do I archive the older forms in an efficient way to free up space on the Sharepoint site ? I need to keep the old forms somewhere else, but I don't want to have to be archiving 1 form at a time.

Is there a way that I can specify that the first 100 forms be dumped out for archiving ?

share|improve this question
    
I wouldn't have mentioned Infopath (in title and tags) since it is question on Sharepoint Server administration but it sounds like a question about Infopath –  Gennady Vanin Novosibirsk Aug 9 '12 at 3:57
add comment

1 Answer 1

Generally, when archiving, having an archiving strategy in place is critical. For example for my current client, we use a record centre and have retention policies that move the form but leave a link in the list. This way the file cannot be edited, since it is a record. But the documents remain in SharePoint itself.

If you are happy for the InfoPath forms to live in a archival site collection, then you can create a workflow (either SP designer, Custom or Nintex) and move the file to the relevant archival site collection based on created date. E.g. http://ikarstein.wordpress.com/2011/02/10/walkthrough-how-to-move-or-copy-a-sharepoint-designer-2010-list-workflow-to-another-list-on-the-same-site-or-another-site/

Now if you are looking for moving the InfoPath forms to a file system, then you will need to use SharePoint object model and write some C#/ powershell code to get the first 100 documents and place them on the file system where they will be backed up. And you can schedule a job on the server so the code runs every day (or as per your schedule) but with this approach there will be no links to these files How to read list items e.g. http://msdn.microsoft.com/en-us/library/ms456030.aspx

Sorry the question was a bit vague so tried to include as much as possible. Hope it helps.

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.