views:

578

answers:

2

I have read some conflicting reports on the net about whether the 4GB limit of SQL Server Express takes into account the contents of FILESTREAM. Can anyone say for certain citing official documentation whether SQL Server Express storage limit is affected by FILESTREAM contents?

+4  A: 

SQL Server Express supports FILESTREAM. The 4-GB database size limit does not include the FILESTREAM data container.

From: http://msdn.microsoft.com/en-us/library/bb895334.aspx

ChristopheD
I'd actually just discovered that very quote and came back to post it! But you beat me so you get the +1 :) Thanks. That's good news!
joshcomley
+1  A: 

According to Mike Wachal (a program manager in the SQL Server group) in this forum post, the pointer information to the blobs is included, but the blobs themselves are not. I know it's not "official documentation", but it does come from someone within the SQL Server group.

adrianbanks

related questions