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.
119 questions
2 votes
2 answers
166 views
Evaluating File Data from FILESTREAM-Enabled vs. Non-FILESTREAM-Enabled Columns in a Single Table
Originally, I was working with .NET 9 and a Blazor web app for admin and a Flutter app for external end-user, but for this context, I constrained it to SQL Server 2017, to evaluate it first internally....
- 205
3 votes
1 answer
107 views
SQL Server Query Store goes into error state with FILESTREAM garbage collection error
I have a database on a SQL Server 2019 instance which has query store enabled and has done for many years All of a sudden, the query store state returned by SELECT actual_state_desc FROM sys....
- 2,256
4 votes
1 answer
347 views
Does enabling FILESTREAM for file I/O access improve performance and manageability in handling file data?
I am trying my best to craft my question as straightforward and clear as possible. So I will start by quoting this answer thread saying that, If you want to read and write FILESTREAM data from ...
- 205
0 votes
1 answer
129 views
How to get partition scheme for filestream data?
Short version: is there a way to get the partition scheme for the FILESTREAM data used by a clustered index created on a partitioned table? Longer version: Say you want to partition a table storing ...
- 93
0 votes
2 answers
112 views
how to divide a filetable to several filetable on several disk in sql server?
I have a dms database that use filestream. I want to distribute data to several disk based on year. How can I divide this database to several disk in sql server? I used Partitioning technique but I ...
- 11
0 votes
0 answers
76 views
Using filestream and log shipping, the file stream doesn't shrink on the secondary, but only grows larger
I'm using log shipping for a database with filestream. The filestream file size on the secondary doesn't correlate with the original file on the primary server. The filestream on the secondary server ...
Ivgeni Dvorkin
0 votes
1 answer
152 views
Restore from database snapshot
When I do a restore of a database from a database_snapshot on a filestream enabled database, I am getting the error: The database cannot be reverted because FILESTREAM BLOBs are present. Is it just ...
- 66
1 vote
1 answer
498 views
Cannot back up a read_only database with FILESTREAM
I'm facing a strange issue where my backup fails with the message: Msg 3906, Level 16, State 1, Line 5 Failed to update database "MyDBB" because the database is read-only. Msg 3013, Level ...
- 3,287
-1 votes
1 answer
154 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 ...
- 151
1 vote
1 answer
553 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 ...
- 11
0 votes
0 answers
315 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 ...
0 votes
1 answer
230 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. ...
- 1
0 votes
0 answers
61 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 ...
0 votes
0 answers
459 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 ...
- 11
-1 votes
1 answer
188 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, ...
- 977