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
3
votes
1
answer
763
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/...
1
vote
1
answer
3k
views
How to fix filestream?
I have SQL Server 2008 R2, when I try to access any value stored in filestream I get the following error:
Msg 233, Level 20, State 0, Line 0
A transport-level error has occurred when receiving ...
- 147
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
2
votes
1
answer
926
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
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
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
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
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
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
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
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