Post reply

max size of file which store to db by filestream in sql server 2008

  • December 5, 2014 at 9:53 am

    #292605

    Hi

    is there limitation for size of file to store in db by filestream in sql server 2008?

    or it accept all sizes?

    Thanks

  • December 8, 2014 at 10:57 am

    #1763329

    there is no limit to filestream files outside of the free space on the volume

    http://technet.microsoft.com/en-us/library/bb933993%28v=sql.105%29.aspx

    FILESTREAM storage is implemented as a varbinary(max) column in which the data is stored as BLOBs in the file system. The sizes of the BLOBs are limited only by the volume size of the file system. The standard varbinary(max) limitation of 2-GB file sizes does not apply to BLOBs that are stored in the file system.

    Bob
    -----------------------------------------------------------------------------
    How to post to get the best help[/url]

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply