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.
112
questions
20
votes
2
answers
15k
views
Restore database excluding FILESTREAM data
Context
We are developing a system with a large-ish database in the bottom. It is an MS SQL database running on SQL Server 2008 R2. The total size of the database is about 12 GB.
Out of these, ...
- 303
14
votes
2
answers
2k
views
In Search of FILESTREAM Insider Information
When the FILESTREAM feature is activated on Microsoft SQL Server 2012 then SQL Server will create a "hidden" share on the system. The share is defined as follows:
Sharename ...
- 17.4k
12
votes
4
answers
1k
views
Keeping (Partial) Backups Small when using SQL Server FILESTREAM
I have a database with nearly 1TB of FILESTREAM data that I don't need backed up (if the data was deleted it'd be recreated automatically in a couple of hours, so it just isn't important). Most of the ...
- 155
8
votes
2
answers
2k
views
Sql server 2008 filestream maximum number of rows
We are using filestreams in Microsoft SQL Server 2008 (SP2) - 10.0.4000.0 (X64) and Windows server 2008 to store millions of files. Since there are millions of files all of them are grouped into 100 ...
- 181
8
votes
1
answer
806
views
Backup and restore SQL server database with FILESTREAM filegroup
I use SQL Server and have a huge database with two filegroups:
Primary: Which contains all the data except the large files (1MB+)
FILESTREAM (read/write): Which contains the large files
Now, the ...
7
votes
1
answer
13k
views
Mapping a shared physical folder to filestream
We are working on a project where we have large amounts of images, texts etc which we need to work on in SQL Server. We were thinking of using Filestream and filetable functionality. However, even ...
7
votes
1
answer
4k
views
How do I move or redistribute FILESTREAM files between containers?
We have a FILESTREAM container with a few million files, and we believe it's the cause of our performance issues we're experiencing (abundant timeouts).
According to this blog about FILESTREAM best ...
- 173
6
votes
1
answer
3k
views
How to get online the database which has missing/corrupted FILESTREAM files?
I've corrupted the files related to FILESTREAM in a database.
The .mdf and .ldf files are still intact, but when I try to get the database online, it complains, saying that the files related to ...
- 693
5
votes
1
answer
1k
views
How do I reclaim space in filestream data files for database in a SQL Server Availability Groups
I have a SQL 2016 Ent. Edition AG with 3 nodes. We have a database in the AG with 5 filestream tables. Each table is in it's own filestream data file. Today I fixed a bug where all of the files were ...
- 205
5
votes
1
answer
244
views
Statistics on filestream column
When I try to create a statistics on a filestream column, I get the following error message:
Column 'MyColumn' in table 'MyTable' is of a type
that is invalid for use as a key column in an index ...
- 11.2k
5
votes
2
answers
1k
views
Replication with FileStream
I need to setup database replication (for high availability) on a database that uses FileStream. This is on SQL Server 2012 Standard Edition, so Always On or Peer-to-Peer replication is not an option. ...
- 51
5
votes
2
answers
5k
views
Please enlighten me about FILESTREAM and BLOB files
This is a really confusing topic for me.
I can understand what a BLOB is, I can easily use it.
I can understand what FILESTREAM is. I can easily implement in on a database, I can backup the database ...
- 7,374
5
votes
1
answer
887
views
Multiple SQL Server instances with FileStream enabled
Is it possible to have two SQL Server instances, one 2008 R2 and another 2012, to run on the same machine with both having filestream enabled?
I tried to setup this in local dev machine and I can get ...
- 71
5
votes
1
answer
1k
views
Move content between filestream containers
I have a server running SQL Server 2012 with Multiple Filestream containers on a single table.
I need to split one of the existing filestream containers into two parts by creating a new filestream ...
- 343
5
votes
1
answer
1k
views
Cannot Delete FileStream Group from Sql Server 2008 [duplicate]
We have migrated all our varbinary(max) column data to Azure Blob Storage and so we want to remove the old filestream columns that remain in our Sql 2008 database and the filestream filegroup but when ...
- 151
4
votes
2
answers
3k
views
SQL Server Enable filestream without having SQL Server Configuration Manager(so via command line only)
I have SQL server 2017 on a Windows Server 2019 Core installation, no GUI. One of our users wants to use Filestream. I tried to follow this setup and this however, since it requires SSCM I can't ...
- 143
4
votes
1
answer
8k
views
Sql FILESTREAM garbage collection issue
Updated 3x
I'm using FILESTREAM, but am having an issue with garbage collection.
The FILESTREAM files are not being cleaned up when I set the column to null.
In the event log, there is an enormous ...
- 141
4
votes
2
answers
2k
views
Better way to store file receipts
I have a financial system that needs to attach PDF receipts for each record saved on my system.
These receipts will be scanned by a proper device attached to the computer and saved in PDF to be ...
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 (...
- 441
3
votes
1
answer
4k
views
Trouble removing filestream file / filegroup
My database was originally using filestreams in one table. For reasons that I won't go into here, we decided to stop using filestreams. I therefore wrote a migration to copy the filestreamed table ...
- 2,923
3
votes
1
answer
8k
views
Removing filestream from a database
I am trying to remove filestream from my database, so I have to do the following
I would like to know how to remove the following:
ALTER TABLE AMGR_Documents_Tbl ADD UId uniqueidentifier ROWGUIDCOL ...
- 61
3
votes
1
answer
3k
views
How can I fix this unexpected Windows Event Log message which appears whenever a database with FILESTREAM is created or restored?
We have recently noticed that whenever we create or restore a database with FILESTREAM enabled, a message like the following is added to the System Event Log:
The description for Event ID 1006 from ...
- 452
3
votes
1
answer
3k
views
Filestream database backup error
We have DatabaseA that has filestream files in it. We then have an archive process which first deletes files in DatabaseB (different server) and then inserts new files from DatabaseA into DatabaseB ...
- 31
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 ...
- 41
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 ...
- 31
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\...
- 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 ...
- 131
3
votes
1
answer
764
views
Create File Stream Enabled Database in Network File (NAS Server)
I want to create a filestream enabled SqlServer database using NAS server as the storage. I already passed the creation of DB step. Look at my previous question https://stackoverflow.com/questions/...
2
votes
1
answer
1k
views
File stream in SQL Server 2008
Hello all I referred to this https://stackoverflow.com/a/5613926/842112
In that they mentioned this
if your pictures or document are typically over 1 MB in size, storing
them in the filesystem ...
- 315
2
votes
1
answer
546
views
Enable File Stream SQL Server 2017
I am trying to enable file stream on Microsoft SQL Server 2017, on a Windows Core 2019 Server.
I have changed the registry settings at the following location to enable it as there is no GUI. I set ...
- 133
2
votes
1
answer
802
views
Storing large image files in database vs system files
I need to store many large photos that will be uploaded daily in my application and retrieve those with id. There is no need to any special queries.
What is the best approach for storing this files ...
- 121
2
votes
1
answer
2k
views
What will be the best suited datatype to store a text file in database [closed]
I want to store a text file containing logs in a database(SQL Server). That file size can vary from 1 MB to 10 MB. what will best suited data type to store it in to the database. Will it be BLOB or ...
- 37
2
votes
1
answer
2k
views
I'm trying to enable SQL Filestream on Windows Server 2012 and SQL Server 2016 64 bit, Management Studio 2017
The machine config is Windows Server 2012, 64 Bit SQL Server 2016, and SQL Server Management Studio 2017. When I use SQL Server Configuration Manager to enable filestream, it gives me an error that I ...
- 141
2
votes
1
answer
6k
views
Backup/restore of a database that has a filestream
I have a SQL DB to which I have recently added Filestream data. Now we have a daily backup/restore to a QA server, and since I added the Filestream data, this has started failing. So I modified the "...
- 2,923
2
votes
1
answer
789
views
How does SQL bind rows in filestream-enabled table with their files
Every BLOB stored in a filestream-Enabled table actually stored in a physical file, How can I know the actual filename for a specific row in that table.
For example, I have the Images table which is ...
- 147
2
votes
1
answer
888
views
Can I create a second filestream container on an existing SQL Server 2008 database without going offline?
Our production DB is using the FILESTREAM option for our sharepoint environment. The volume where the files are residing is getting full and I am planning to add another volume to ease space issues. ...
2
votes
1
answer
2k
views
Oracle SQL Loader - load file where record is composed of "n" delimiters
How would you write a control file for Oracle SQL Loader that treats each record as being composed of 3 commas?
I have read the documentation, however I cannot find how to handle this scenario, ...
- 21
2
votes
1
answer
491
views
How to attach a sql db with blobs using a shared folder?
I use the following query for attaching a sql db:
CREATE DATABASE [myDb] ON
(FILENAME=N'C:\myDb\myDb.mdf'),
(FILENAME=N'C:\myDb\myDb_log.ldf'),
(FILENAME=N'C:\myDb\FILESTORE')
FOR ATTACH
In ...
- 67
2
votes
1
answer
129
views
onsite and offsite backup question
We have an sql database of 165GB (includes filestreaming) and we do an onsite full backup every evening using veritas. We would like to also have an online backup in place just so that we don't need ...
- 21
2
votes
1
answer
3k
views
Feature SQL Server 2012 - Filetable - The location of the file can not be opened
When trying to access the files available on the virtual directory created for FileTable, you receive the following error message:
"The location of the file can not be opened. Access is not enabled ...
- 83
2
votes
1
answer
927
views
Fastest way to determine size of groups of FILESTREAM objects
We have a sql FILESTREAM enabled table, and are wondering what the fastest way is to determine the size grouped by a common criteria, as well as the sum of all objects.
To date, we have been using ...
- 190
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 ...
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' ...
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-...
- 121
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:
...
- 109
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 ...
- 141
1
vote
1
answer
153
views
Is there a limit on the number of blobs storable in SQL Server with filestream?
I use filestream to store blobs (files). I use SQL Server 2008 R2
Some customers have 60k files (50GB). They ask me if there is a limit after which, also because of NTFS, there will be problems.
...
- 143
1
vote
1
answer
443
views
FileStream Db restore
Microsoft SQL Server 2016 (SP1-CU6) (KB4037354) - 13.0.4457.0 (X64)
The database's total size is 450 GB, from which 350GB is inital filestream size
The average picture size is around 200Kb, the ...
- 11
1
vote
1
answer
300
views
Suggestions - Enabling EFS on FileStream Data for SQL Server
If anyone has already tried enabling EFS on FileStream data for multiple databases around 500 GB+, please share your thoughts on feasibility or issues / considerations we should keep in mind.
We are ...
- 1,580
1
vote
1
answer
3k
views
FILESTREAM is enabled, but I get a message that it's not. Anyone able to help?
I have been given the task of setting SharePoint Foundation 2010 up in work. I have hit quite a few problems (see other questions I have posted), so I decided to start from scratch again. I have ...
- 35