SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,758 questions
BFILE alternative in SQL Server
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(12.8, 31%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJA%3C/text%3E%3C/svg%3E)
Jassim Al Rahma
1,526
Reputation points
Hi,
What is the datatype available in Microsoft SQL Server to use that is similar to the BFILE in Oracle where you store a pointer of to the file?
Thanks,
Jassim
{count} votes
-
CathyJi-MSFT 21,096 Reputation points Microsoft Vendor2022-05-19T03:17:59.587+00:00 Hi @Jassim Al Rahma ,
Please check the replies from NaomiNNN and Tom. If the response helped, do "Accept Answer". Your contribution is highly appreciated. If you have further issue, pleas feel free to ask.
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(246.4, 44%, 33%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJA%3C/text%3E%3C/svg%3E)
Jassim Al Rahma 26 Reputation points2022-05-19T16:16:47.123+00:00 Is this available in Microsoft SQL Server Express as well?
and does the actual file size count in the total database size or it will only have a reference to it? because if the actual file size will consume from the SQL Express database size then that won't be enough.
-
Erland Sommarskog 101.4K Reputation points MVP2022-05-19T21:13:51.12+00:00 FILESTREAM is available on SQL Server Express. Good question if they count the size of the FILESTREAM area when they check the 10 GB limit. You will need to test.
But the files are indeed part of the database, so when you backup the database, the files are included. So from that perspective, if you exceed the limit, you have found a loophole.
There is also Filetable. The difference is that with FILESTREAM, the area where the files are located are off-limits, wheras with Filetable, a share is exposed and files can be entered through regular Windows tools. Again, I don't know how that relates to the 10 GB limit.
Sign in to comment
2 answers
Sort by: Newest
-
-
Naomi 7,361 Reputation points2022-05-18T20:51:36.407+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(67.2, 1%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETP%3C/text%3E%3C/svg%3E)