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
109
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
155
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
501
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
161
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
554
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