The filestream tag has no wiki summary.
1
vote
1answer
21 views
Restore a Single File from FileStream
We have an document management application uses SQL Server 2012 to store document index information and uses a Windows file share to store the documents. We are working on migrating to store the ...
1
vote
1answer
12 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 Creating SQL Server database with data ...
0
votes
1answer
53 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 ...
3
votes
1answer
164 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 ...
2
votes
0answers
66 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 ...
7
votes
2answers
385 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 ...
5
votes
1answer
570 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 ...
8
votes
2answers
1k 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, ...
1
vote
1answer
241 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 ...
2
votes
1answer
141 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
1answer
413 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, ...
2
votes
1answer
263 views
File stream in SQL Server 2008
Hello all I referred to this http://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 ...
1
vote
1answer
1k 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 ...
