SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I have a need to generate documents and send them to a email address. Once the document has been sent I don't actually care about the generated document, oh and it has to be a document, formatted HTML emails don't meet the requirements.

Because the documents need to be templated I'd like to set up a library with a default document template that uses smart so that I can create a new item in the library using the API, set the metadata for the document and have the content set how I need it for this document instance.

I'd then attach the file to a email and send it.

Once the email is sent I'd like to delete the item from the library to make sure I'm not storing things I don't need to.

The question is will SharePoint manage this deletion properly and ensure that my content DB doesn't grow due to documents that have been deleted?

share|improve this question
up vote 0 down vote accepted

Documents deleted from a library continue to live in the site Recycle Bin, and as such continue to occupy storage space.

Once they are removed or expired from the bin however, they are cleaned from the content table. Traces might remain for example in the Change logs or Audit logs, but these are either expired automatically or can be cleaned up. Your actual database files will eventually recover the released blocks in SQL.

So, yes, deletion will be handled properly.

share|improve this answer

Your Answer


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.