Stack Exchange Network

Stack Exchange network consists of 174 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

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.

0
votes
1answer
28 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 ...
2
votes
0answers
23 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 ...
0
votes
0answers
16 views

Moving the FileStream Data Drive to New Location and enabling EFS

Can any of the MS FileStream experts help me on below: I do have the 5 App DBs with FileStream enabled. Current the size of **C: for FileStream Blob data is 5 TB** All the DBs have below drive ...
0
votes
1answer
25 views

FileStream files won't deleted after records deleteion

I am working in sql server 2016 with Filestream attribute column. I have a column with filestream attribute activated on it. when I insert a reacord in TSQL , the associated file is created in ...
2
votes
0answers
121 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 ...
5
votes
2answers
518 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 ...
0
votes
0answers
23 views

Restoring a backup that uses FILESTREAM into an AlwaysOn Availability Group

I built two SQL servers using the SQL 2014 SP2 Enterprise on Windows Server 2012 R2 marketplace item on Azure, then clustered them into a Windows Failover Cluster and created an AlwaysOn Availability ...
2
votes
0answers
26 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' ...
3
votes
0answers
52 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 ...
0
votes
1answer
81 views

Is the filestream in SQL Server backed up when using standard backup techniqe

I'm using a SQL-Server 2014 database with filestream enabled. To backup this database I'm using the powershell command Backup-SqlDatabase, which is equivalent (as fas as I know) to T-SQL BACKUP ...
1
vote
0answers
62 views

Filestream directory exists for a partition but the corresponding partition does not exist in the database

I am investigating a high memory usage issue of tempdb on a production SQL Server 2017 Enterprise (64-bit) deployment. This is similar to an issue discussed here. The server has two production DBs ...
0
votes
1answer
220 views

Removing a FILESTREAM windows share after uninstall

I had to uninstall my local SQL 2017 Dev edition on my home PC (Windows 10) because I changed some drive structure (including where all the system databases lived) a while ago, so I needed to ...
1
vote
1answer
171 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 ...
0
votes
0answers
100 views

archiving partitioned filestream table

I've a database on SQL Server 2016 SP1, in the db there is only one table with a Filestream column and a few columns of type varchar. The table is partitioned and every month a new partition is added ...
0
votes
2answers
134 views

T-SQL to find Database name and if Filestream is enabled for specific Database

Please help me on below query . NOTE : Please excuse my programming skills , the code is of mistakes . I want the output like Database name in one column and the FileStream enabled or disabled in ...
0
votes
1answer
396 views

Calculating the FileStream Data Columns Length matching used FS Drive used space

Kindly advice me on below : I am process of calculating the total size of LOB objects with below data types (includes Views and user schema tables) . select * from information_schema.columns where ...
0
votes
1answer
259 views

How do I grant Read Access to FILESTREAM data in a table but not grant SELECT access?

Problem: I want users to be able to download data stored in a table that contains a FILESTREAM column. Each file is typically 200 to 500 MBytes. I however do not want to grant the user SELECT ...
0
votes
1answer
86 views

Difference between FILESTREAM and set a path for the file

I think I know about the basic of these situations. 1) when you insert a .PDF file into a database, it will be inside the .MDF file: INSERT INTO normal_table(id ,nome_arquivo,arquivo) SELECT 1,'...
1
vote
0answers
31 views

Buffer Pool in SQL Server FileStream

One of the best feature of FileStream is : The SQL Server buffer pool is not used; therefore, this memory is available for query processing. I have encountered an issue that If I create a stored ...
8
votes
1answer
339 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 ...
13
votes
2answers
566 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 FILESTREAM_SHARE ...
0
votes
1answer
1k views

Problem with restoring database which has a filestream

When I restored a database backup file, which uses FILESTREAM feature, everything was fine but after a while the database went to the (recovery pending) mode. I tried restarting SQL Server service and ...
3
votes
0answers
247 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\...
0
votes
2answers
106 views

File Stream Data Clarification

If at all File stream option is enabled. Will sp_helpdb show the database size which includes even FileStream Data. Or only .mdf and .ldf sizes ?
4
votes
1answer
709 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 ...
2
votes
1answer
413 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 ...
2
votes
0answers
119 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-...
1
vote
2answers
578 views

Is there any impact whatsoever of enabling FILESTREAM on active SQL Server?

I may have to enable Filestream on a live SQL Server at work, but first need to know about the possible impact/implications of doing so on the performance/operation of the databases held therein. I ...
1
vote
0answers
96 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
95 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
361 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
2k 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
162 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 ...
12
votes
4answers
807 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 ...
1
vote
2answers
700 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 ...
1
vote
0answers
815 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
11k 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
126 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 ...
4
votes
2answers
1k 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
74 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
717 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
507 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 ...
2
votes
1answer
4k 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
639 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
2k 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
765 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
3k 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 ...
1
vote
2answers
958 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
378 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
563 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 ...