Sharepoint Forum

Ask Question   UnAnswered
Home » Forum » Sharepoint       RSS Feeds

sharepoint document blob DB storage

  Asked By: Krista    Date: Oct 19    Category: Sharepoint    Views: 820

My boss has asked me to check something and I'm just finding it
difficult to find an article that confirms it.

I believe that sharepoint stores each version of a document as it's own
blob entry in the database.

(eg upload 3 versions of 10mb document will take up 30mb of storage).

That it is does not employ any fancy single instance storage (eg as in
the exchange DB ) or delta only changes between versions.

Can anyone confirm this for me?



4 Answers Found

Answer #1    Answered By: Chantal Rosa     Answered On: Oct 19

Sadly, this is true..............

Answer #2    Answered By: Kyla Eckert     Answered On: Oct 19

The ability to have the blobs stored outside of SQL Server will be part of
Service Pack 1.

Answer #3    Answered By: Alisha Holmes     Answered On: Oct 19

Yes, each version  is a complete version.

So, 3 versions  of a 10MB doc will take 30MB of storage. Bad for storage,
good for restores when the user does the ctrl+A,backspace,save combo

Answer #4    Answered By: Alexis Ellis     Answered On: Oct 19

Maybe with the next version  of SQL and Sharepoint they can be a little
bit more fancy with the storage  subsystem.

Didn't find what you were looking for? Find more on sharepoint document blob DB storage Or get search suggestion and latest updates.