Maximum file sizes for storage

[scaiferw]

To the best of my understanding, files in Vault are stored in the database as BLOBs with the varbinary data type which has a maximum size of 2GB less one byte.

I am told that SQL Server 2008 has a FILESTREAM storage method, which would surpass this limit.

Am I correct about the BLOBs being stored as varbinary?
Is this FILESTREAM Storage an option if we were to upgrade our DB to SQL Server 2008?
If this capability isn't presently available in any configuration, is it on the horizon?

We have occasional need to store files as large as 5-6GB, and someone has suggested storing 40GB files, though I question the performance implications of that.

Many people here asking me questions!

Thanks,

Rob

[lbauer]

Vault was originally designed for source code files, which rarely hit the 2 GB limit. Vault doesn't currently support the Filestream storage method.

However, we do hear from users who would like to store larger files in Vault. We have feature request 15879 for this functionality; I've added your "vote." We'll consider this for a future Vault release.

[scaiferw]

Thanks Linda.

Am I correct that the BLOBs are currently stored as varbinary()?

Rob

[lbauer]

Yes, that's correct.