0
votes
1answer
29 views

How to get SQL Server filetable path locator for subfolder by its literal path

I have a filetable which have several subtables. For example FileTable ->subtable1 ->->subtable1.1 ->->subtable1.2 ->subtable2 ->subtable3 etc How to get SQL Server ...
0
votes
0answers
25 views

Drawbacks of storing files in a database [duplicate]

I have developed a web application, with a page page that uploads pdf files and stores them in a database table. Is there any performance decrease or other drawbacks of this storage approach? Is there ...
1
vote
0answers
30 views

Transactions using Isolation Level on databases with FileStream

We have a highly transactional application. We have a requirment to upload huge data into our database that can happen for a duration of 5-10 minutes. During our upload time, the tables are getting ...
3
votes
2answers
96 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. ...
1
vote
1answer
41 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. ...
2
votes
0answers
83 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 ...
0
votes
0answers
96 views

Recover deleted records from filestream-enabled table

I have a SQL Server database that I wrongly executed a delete script on it that removed an important records from a filestream-enabled table called Images. after the execution immediately I created a ...
1
vote
0answers
245 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 ...
1
vote
0answers
303 views

Configured values different to Running values, even after full restart

I am trying to change the FILESTREAM Access Level property on a SQL Server Express database. The Configured values section of the Advanced tab of my Server Properties dialogue box looks like so: ...
4
votes
1answer
2k 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 ...
2
votes
0answers
282 views

Cannot Delete FileStream Group from Sql Server 2008

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 ...
3
votes
1answer
177 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
574 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 ...
7
votes
2answers
784 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 ...
6
votes
1answer
960 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 ...
15
votes
2answers
3k 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, ...
2
votes
1answer
246 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. ...
3
votes
1answer
2k 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 ...