Questions tagged [filestream]

Use the FILESTREAM tag when referencing Microsoft's SQL Server FILESTREAM feature which allows developers/admins to store binary data on the file system instead of in the tables.

37 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
4 votes
1 answer
1k views

Can we use FILESTREAM in case of SQL Server cluster

I saw this point on Technet article about RBS. The local FILESTREAM provider is supported only when it is used on local hard disk drives or an attached Internet Small Computer System Interface (...
Frank Martin's user avatar
3 votes
0 answers
577 views

Why the disparity between Filestream size and Container folder size?

I have an issue with one of my SQL Server 2014 databases. It appears to me that the Filestream size is significantly larger than the actual Filestream container folder size? ~360Mb larger. The ...
Incertainty's user avatar
3 votes
0 answers
79 views

database restore with filestream on Windows Server 2016 renames data file

I have a database in SQL Server 2008 R2 sp2 that has filestream enabled. Restore of the database on a Win10 machine works as it should. However, on Windows Server 2016, the data directory (file) for ...
Ed Madigan's user avatar
3 votes
0 answers
827 views

Accessing FILESTREAM share by a user on another domain with full trust

I have a FILESTREAM share on a SQL server in domain AAA and a users in domain AAA and BBB. The two domains have a full trust. Users in domain AAA can access the share from UNC \server\mssqlserver\...
SEAKDev's user avatar
  • 31
3 votes
0 answers
2k views

SQL Server FileTables (File Stream) file Corruption

We're running an implementation of SQL Server 2012 FileTables with several scientific instruments with PCs that write data directly to a mapped drive of a FileTables share. The size of this share is ...
dansan's user avatar
  • 131
2 votes
0 answers
755 views

Filestream access denied via UNC / SQL

I am having an issue with filestream and accessing the files. From the server itself I can access the files in the filestream folder when browsing direct on that computer. However when I try to browse ...
Jesse Pearson's user avatar
2 votes
0 answers
127 views

Filestream File Share does not allow files to be created

When attempting to create a file or folder in a SQL filestream file share, Windows presents the following dialog: For those who cannot see the image, the error reads "The file 'New Text Document.txt' ...
Chris Crutchfield's user avatar
2 votes
0 answers
165 views

How to fix the relationship between MSSQL database and associated FILESTREAM files

TL;DR: How can I fix the relationship between an MSSQL database and the associated FILESTREAM files for a database that was recovered from failed disks? Background A server hosting a FILESTREAM-...
Jens Ehrich's user avatar
2 votes
0 answers
1k views

FILESTREAM access stuck in broken state

Following a reboot, two of our databases were marked as “Recovery Pending” and could not be accessed. These databases are both using FILESTREAM. In trying to fix them, we attempted the following: ...
KRISTOPHER COOK's user avatar
2 votes
0 answers
338 views

Maintaining Referential Integrity with a Filestream enabled database

We have a production database which is filestream enabled and has grown, within a year, to about 20Gb as it stores documents. On many occasions we need to bring the live data back to UAT or Dev ...
John J Smith's user avatar
1 vote
1 answer
187 views

Can JDBC Oracle file stream blob inserts be speeded up?

I have these four different ways by which I am inserting some file data into an Oracle database using JDBC and PreparedStatements. Approach A ps.setBytes(1, fileDataInByteArray); Approach B Blob ...
Raster R's user avatar
1 vote
1 answer
1k views

Enable SQL Server FILESTREAM - Windows Based Docker Container (not linux)

I have been struggling for a few days to spin up a windows based docker container running SQL Server 2017 on Windows Server Core 2016. I am using the following image as a starting point: https://hub....
Joachim Prinsloo's user avatar
1 vote
0 answers
403 views

How to select all files of a SQL Server database from blob folder?

I have a SQL Server database. You can use the following script to create similar database: CREATE DATABASE [test] CONTAINMENT = NONE ON PRIMARY (NAME = N'test', FILENAME = N'C:\Program Files\...
isxaker's user avatar
  • 67
1 vote
0 answers
53 views

DCM page in Filestream_Data_Filegroup

I'm doing some research about the DCM (Differential Change Map) page in SQL Server 2016. This is what I discovered so far: page type: 16 each DCM page covers a GAM interval each data file has a DCM ...
Frederik Vanderhaegen's user avatar
1 vote
1 answer
241 views

Measuring Availability Group synchronization lag - Clarifications

Can I get some help on below As I have started and learning about the Measuring of Availability Group synchronization lag between replicas inclusive of BCP , I want to understand and learn that does ...
Learning_Learning's user avatar
1 vote
1 answer
419 views

Filestream directory exists for a partition but the corresponding partition does not exist in the database

I am investigating a high memory usage issue of tempdb on a production SQL Server 2017 Enterprise (64-bit) deployment. This is similar to an issue discussed here. The server has two production DBs ...
Jacobus Herman's user avatar
1 vote
0 answers
43 views

Buffer Pool in SQL Server FileStream

One of the best feature of FileStream is : The SQL Server buffer pool is not used; therefore, this memory is available for query processing. I have encountered an issue that If I create a stored ...
Arian's user avatar
  • 439
1 vote
0 answers
161 views

McAfee antivirus and File stream SQL Server 2008 R2 Issue

I am facing file stream issues in SQL Server 2008 R2 and I am not able to correlate things and how to fix them. Below are the event logs. Please let me know if they both the errors (One is Mccafee ...
Learning_Learning's user avatar
1 vote
0 answers
112 views

Single volume for five Filestream databases

We are going ahead with PROD server setup. SQL Version 2014 AOAGs. I have a question about the M:\ holding 5 Filestream databases totaling 1.5TB. What will be the operational risks of running one ...
Learning_Learning's user avatar
1 vote
0 answers
2k views

FILESTREAM shared folder can not be accessed using listener name

I have AlwaysOn configured in SQL Server 2014 and enabled Filestream in both nodes (node 1 and node2) as shown here: Enable and Configure FILESTREAM (MSDN Library) I have named the shared folder ...
kudlatiger's user avatar
1 vote
0 answers
1k views

Converting existing table with varbinary into filestream enabled table?

I have an existing database with 70%+ data in one table with a varbinary column. As the database keep growing (takes longer and longer to backup and restore) I think it may be beneficial to enable ...
elty123's user avatar
  • 421
1 vote
0 answers
246 views

Deleting already duplicated Filestream Files

I have three FileStreams (FS1 on F drive, FS2 on H drive, FS3 on E drive) belonging to the same FileStream group of one particular database (DB) which is in Simple recovery mode in the SQL Server 2012....
Anandita Sharma's user avatar
1 vote
0 answers
490 views

Transactions using Isolation Level on databases with FileStream

We have a highly transactional application. We have a requirment to upload huge data into our database that can happen for a duration of 5-10 minutes. During our upload time, the tables are getting ...
Vinoth's user avatar
  • 111
0 votes
0 answers
120 views

I cannot write information to a filesystem file from my newly installed MS SQL Server

Hello and thank you for your help. I must write non-tabular information to a file. I have tried a few methods that invoke various stored procedures. The following SQL statement tests this and I ...
Craig McWilliams's user avatar
0 votes
1 answer
87 views

How to restore a SQL Server bak file (Enabled FileStream ) to Docker version SQL Server?

I have SQL Server 2014 installed on Windows and enabled the FileStream feature. I backed up the database to a .bak file. Now I want to restore the file to my Docker container of SQL Server 2019. ...
XBruce's user avatar
  • 1
0 votes
0 answers
15 views

filestream fulltext-index language-for-wordbreaker

I need to use "_" as a word breaker for full text search. Setting the language as Korean does what I need: SELECT * FROM sys.dm_fts_parser ('Happy_Hour',1042,0,0) When I put "'...
Ping S's user avatar
  • 1
0 votes
0 answers
39 views

Backward compatibility for filestream databases

I have a database on a filestream enabled instance and with file system tables on SQL Server 2019. I am able to generate scripts for schema and data permitting restore on earlier SQL Server versions ...
franklwambo19's user avatar
0 votes
0 answers
239 views

SQL Server FILESTREAM Object Garbage Collection in a Always On Availability Group

We have a production SQL Server 2014 running on FILESTREAM with Always On Availability Group. It has been about 4 years since the servers go live. Recently, we encounter a hard disk space issue on the ...
L.C. Tan's user avatar
0 votes
0 answers
113 views

Unable to get FileStream Length with After Insert trigger

I asked this question on StackOverlow, but it mostly received comments about the use of variables and no answer. I program mainly in VB.Net, so my T-SQL knowledge is limited. The reason I'm populating ...
merlot's user avatar
  • 1
0 votes
0 answers
360 views

Why is the FILESTREAM data not accessible, after AG listener is created?

I'm having a hard time figuring out why my app can't access filestream data, after we enable AG listener. Background info: Initial environment: APP Server Web Server IIS Windows Server 2012 R2 DB ...
Ilfad Hasanovic's user avatar
0 votes
2 answers
177 views

How to open a sqlserver FileStream Feature without a restart of the sqlserver instance service?

I've seen replying for how to enable the filestream feature by a sql statement. but when the feature is opened, how to restart the sqlserver service instance to made it effects?
Charming Green's user avatar
0 votes
0 answers
110 views

SQL Backup Operation has detected an unexpected file in a FILESTREAM container, what should I do?

BACKUP DATABASE [DB] TO DISK = N C:\Program File... failed with the following error: The backup operation has detected an unexpected file in a FILESTREAM container. The backup operation will ...
SQLSeeker's user avatar
0 votes
1 answer
182 views

change file table file stream data folder faces error The container can not be dropped

I want to change file database file stream folder from Drive D to Drive F. I successfully transferred data to new folder but when I want to Remove old file stream folder I face this error: "The ...
Mohammad Ali Barati's user avatar
0 votes
0 answers
228 views

Moving Files in SQL as Blob (Filestream)

I have setup both of my Servers with Filestream for T-SQL access (and my DBs). I created tables on both Servers: CREATE TABLE mytable( [UI] UNIQUEIDENTIFIER ROWGUIDCOL NOT NULL UNIQUE DEFAULT (newid()...
phoinix's user avatar
0 votes
1 answer
118 views

Enabling EFS on FileStream Folders

Please help me on below: Below is my Environment: Windows Server 2012 R2 Standard SQL Server 2014 SP2 GDR Availability Groups 2014 with 3 Node (2 Sync and 1 BCP async) I have 7 Databases with ...
Learning_Learning's user avatar
-1 votes
1 answer
28 views

SQL Server: attach database with filestream error 5

I'm trying to attach a database with full text catalog and filestream, but I'm having some issues with the file stream part. Here's the SQL I'm using (according to this article, this should work): use ...
Luis Abreu's user avatar
-1 votes
1 answer
136 views

Attach of renamed files conflicts with original files

I am having difficulties attaching DB in a certain environment while the same scenario works in my dev or other production instances. SCENARIO There is a backup of database files (MDF, NDF, LDF, ...
jericzech's user avatar
  • 945