The tag has no usage guidance.

learn more… | top users | synonyms

1
vote
0answers
22 views

McAfee antivirus and File stream SQL Server 2008 R2 Issue

I am facing file stream issues in SQL Server 2008 R2 and I am not able to correlate things and how to fix them. Below are the event logs. Please let me know if they both the errors (One is Mccafee ...
1
vote
0answers
54 views

Single volume for five Filestream databases

We are going ahead with PROD server setup. SQL Version 2014 AOAGs. I have a question about the M:\ holding 5 Filestream databases totaling 1.5TB. What will be the operational risks of running one ...
0
votes
0answers
46 views

Speed Up Garbage collection in FileStream process

In my current process, we have two production site SQL Servers 2014 (Sync), and one DR site SQL Server 2014 (ASync) in one WSFC. I will be hosting 5-6 databases for AOAG set up, out of which one of ...
6
votes
1answer
151 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 ...
0
votes
0answers
25 views

Move large text field to filestream without having to rewrite all codes MSSQL

My MS SQL Express Database keeps hitting the 10G limit. In a few months, we will migrate to Azure DB. In the mean time, to avoid problems, I'm thinking moving a huge text field (storing long html ...
0
votes
0answers
34 views

SQL Server - “…failed to retrieve text for this error. Reason: 317” error on FILEGROUP

I log in on my local SQL Server 2012 via Windows Authentication. If I try to execute: CREATE DATABASE MediaDB ON PRIMARY ( NAME = FileStreamDB, FILENAME = 'C:\temp\FS\MediaDB.mdf'), FILEGROUP ...
12
votes
3answers
168 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 ...
0
votes
0answers
30 views

Unable to Remove Filestream Filegroup and Associated Database File

I had 5 FileTables which I have since converted to regular tables with varbinary(max) columns instead, migrated all the data from the filetables to the new tables and dropped the filetables completely....
1
vote
2answers
75 views

Can I access the file stream shared folder using Listeners in case of AlwaysOn cluster environment?

One of the most effective ways to extend your SQL Server Integration Services (SSIS) control flow is to use a Script task to write custom code that perform tasks you cannot perform with the built-in ...
0
votes
0answers
21 views

Here there is any way to read or open binary files that exists in Filestream enabled RBS folder?

There is a sharepoint content database configured with Remote BLOB Storage. if any user upload documents to sharepoint it saved in RBS folder as a binary file and it has reference to content database ...
1
vote
0answers
120 views

FILESTREAM shared folder can not be accessed using listener name

I have AlwaysOn configured in SQL Server 2014 and enabled Filestream in both nodes (node 1 and node2) as shown here: Enable and Configure FILESTREAM (MSDN Library) I have named the shared folder ...
0
votes
1answer
422 views

Best way to store images in SQL Server 2014

I am working as database developer (intern), and I have to find out the best way to store image files in SQL Server 2014. Could anyone suggest the best solution? I have found that if the file size is ...
5
votes
1answer
41 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 ...
0
votes
0answers
32 views

Entity Framework using filestream

Does Entity Framework support file I/O using Win32 / .net API's? From online it states that Entity Framework only supports filestream using T-SQL which again can bloat the buffer pool and cause ...
0
votes
0answers
16 views

Filestream Security using FileIO

It's very confusing online about security using file IO using win32 API's. Does SQL instance need to run under windows account ? Can application impersonate the SQL login that is used to a windows ...
4
votes
2answers
317 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 ...
2
votes
1answer
41 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 ...
1
vote
1answer
76 views

Moving FILESTREAM to another database

Our development organization has created an application employing FILESTREAM, which through the pilot has been incorporated into a schema within our Data Warehouse Staging database. Going to ...
4
votes
1answer
123 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 ...
0
votes
0answers
191 views

PREEMPTIVE_OS_FILEOPS when querying Filestream

I've have a table which contains a Filestream column, when I query the table as follows: SELECT ID, FileContent --, * FROM dbo.Files AS f WHERE FileContent IS NOT NULL AND ID = '...
2
votes
1answer
226 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 ...
1
vote
0answers
96 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: ...
0
votes
1answer
548 views

Need to make sense of FileTable permissions

I'm setting up a FileTable to allow users to quickly stuff some PDF report files into a database for later searching via an intranet application (to be built later). Sorting out the necessary ...
5
votes
1answer
286 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 ...
2
votes
1answer
618 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
votes
2answers
311 views

Restore Error event id 17066 and 3624 while restoring diff backup

I am getting the following error while restoring the Diff back up after restoring the Full backup in Norecovery mode. I am unable use dbcc checkdb as the database in restoring db.Issues happens only ...
1
vote
2answers
105 views

Move a Filestream column between tables

I have a table which has a Filestream column which I would like to move to another table. Is this possible without having to do a "manual" move of the data (create target column; issue UPDATE/INSERT ...
0
votes
1answer
163 views

Database with FILESTREAM enabled gives Error 3056 during backup

I have a SQL 2014 database enabled for FILESTREAM and I am getting errors 3056 during backup. The message is DESCRIPTION: The backup operation has detected an unexpected file in a FILESTREAM ...
2
votes
1answer
347 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 ...
4
votes
1answer
166 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 ...
1
vote
0answers
222 views

Converting existing table with varbinary into filestream enabled table?

I have an existing database with 70%+ data in one table with a varbinary column. As the database keep growing (takes longer and longer to backup and restore) I think it may be beneficial to enable ...
1
vote
0answers
83 views

Deleting already duplicated Filestream Files

I have three FileStreams (FS1 on F drive, FS2 on H drive, FS3 on E drive) belonging to the same FileStream group of one particular database (DB) which is in Simple recovery mode in the SQL Server 2012....
0
votes
1answer
1k views

SQL Server FILESTREAM access denied

I have my machine and a database server on the same Windows domain. I also have a staging machine that is not on the domain. From my machine, I am able to perform any and all operations using ...
1
vote
1answer
2k 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 ...
1
vote
1answer
3k 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 "...
1
vote
1answer
657 views

SQL Server 2008 R2, error creating file for FileStream

I'm trying to create a file to add to a filestream file group and I get the error: Msg 5120, Level 16, State 106, Line 1 Unable to open the physical file "d:\data\filestreamstore.mdf". Operating ...
1
vote
0answers
175 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 ...
0
votes
2answers
1k views

SQL Log Messages - FILESTREAM and xp_cmdshell

I was perusing the SQL logs today and found the following: FILESTREAM: effective level = 0, configured level = 0, file system access share name = 'MSSQLSERVER'. Configuration option '...
5
votes
2answers
470 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
70 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
183 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
178 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 ...
2
votes
1answer
319 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 ...
1
vote
0answers
684 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
1answer
2k 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 ...
1
vote
0answers
1k 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: ...
5
votes
1answer
6k 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 ...
4
votes
1answer
770 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 ...
1
vote
1answer
402 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 ...
3
votes
1answer
379 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 ...