1

I use filestream to store blobs (files). I use SQL Server 2008 R2

Some customers have 60k files (50GB). They ask me if there is a limit after which, also because of NTFS, there will be problems.

Somehow the doubt is: if the number of blobs grows too much is there a limit beyond which SQL Server will not handle them properly or not?

I think SQL Server handles this well, but does anyone has a better reply?

Thanks

5

60.000 files and 50 GB should be absolutely no problem. You might want to read "Special Consideration for Large Environments".

A challenge could be to come up with a recovery plan.

|improve this answer|||||

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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