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.

Filter by
Sorted by
Tagged with
-2
votes
0answers
10 views

The network name cannot be found at System.Data.SqlTypes.SqlFileStream.OpenSqlFileStream

I have 3 Node SQL 2014 AOAG Cluster. Replica1 & Replica2 are syncronized replicas. Recently , while trying to check the Application status , I started seeing below error in previous primary (AG ...
0
votes
2answers
47 views

Guidance on strategy for serving files remotely using SQL Server

Thanks for the help. "I" am the IT department for a small business and my ignorance may keep me from asking the right questions so please bear with me. Currently, we are using MS Access ...
0
votes
0answers
19 views

FileStream DB SQL Server - merging DB data

We recently upgraded a server from 2014 to 2017. Since down time was a concern, we migrated some DB's a couple days before. Migration complete Sunday afternoon, we've now come to find out the ...
0
votes
0answers
14 views

Filestream or FileTable…what should be used to solve the problem

I've been assigned with a project that includes converting the columns in the existing tables to use FileTable or Filestream. Basically, the requirement is to move blob fields to filetable storage if ...
0
votes
0answers
35 views

Moving Files in SQL as Blob (Filestream)

I have setup both of my Servers with Filestream for T-SQL access (and my DBs). I created tables on both Servers: CREATE TABLE mytable( [UI] UNIQUEIDENTIFIER ROWGUIDCOL NOT NULL UNIQUE DEFAULT (newid()...
2
votes
1answer
54 views

Enable File Stream SQL Server 2017

I am trying to enable file stream on Microsoft SQL Server 2017, on a Windows Core 2019 Server. I have changed the registry settings at the following location to enable it as there is no GUI. I set ...
1
vote
0answers
55 views

How to select all files of a SQL Server database from blob folder?

I have a SQL Server database. You can use the following script to create similar database: CREATE DATABASE [test] CONTAINMENT = NONE ON PRIMARY (NAME = N'test', FILENAME = N'C:\Program Files\...
0
votes
1answer
57 views

Can't open Microsoft Access Database inside a Microsoft SQL Server Filetable Folder

We recently started to migrate the Data on our Fileserver to SQL Server (Version 14) Filetables and I encountered a problem with MS Access Databases (.accdb, Access 2007). When the .accdb file is ...
1
vote
1answer
452 views

SQL Server Enable filestream without having SQL Server Configuration Manager(so via command line only)

I have SQL server 2017 on a Windows Server 2019 Core installation, no GUI. One of our users wants to use Filestream. I tried to follow this setup and this however, since it requires SSCM I can't ...
1
vote
1answer
103 views

What is the purpose of keeping filegroup or filestream backup in MSSQL?

I'm a new DBA for SQL SERVER. Currently I'm learning about filestream on SQL server. So I tried to restore only filegroup of filestream to other database, but I get an error message: An exception ...
1
vote
0answers
22 views

DCM page in Filestream_Data_Filegroup

I'm doing some research about the DCM (Differential Change Map) page in SQL Server 2016. This is what I discovered so far: page type: 16 each DCM page covers a GAM interval each data file has a DCM ...
2
votes
1answer
104 views

How to attach a sql db with blobs using a shared folder?

I use the following query for attaching a sql db: CREATE DATABASE [myDb] ON (FILENAME=N'C:\myDb\myDb.mdf'), (FILENAME=N'C:\myDb\myDb_log.ldf'), (FILENAME=N'C:\myDb\FILESTORE') FOR ATTACH In ...
1
vote
0answers
66 views

SQL Server Transaction Log Full affect on FileStream [closed]

These are general question I would like to receive some inputs from experts with BLOB SQL Data. How will SQL Server Transaction Log (.ldf file) linked to SQL Server FileStream Is it different from ...
1
vote
1answer
38 views

The MS documentation on FILESTREAM makes it sound like it should only be used for archiving unstructured data. Am I misunderstanding this?

I am building an application that will store small image files (probably less than 1 MB typically) associated with records. I am considering the FILESTREAM option in MSSQL, but I'm a little confused ...
1
vote
0answers
29 views

Removing large image files from production database [duplicate]

The database design for a retail organization has several tables with image columns. These account for around 40% of the table size due to their large size. (Many a DBA issues come from inheriting ...
1
vote
1answer
101 views

Measuring Availability Group synchronization lag - Clarifications

Can I get some help on below As I have started and learning about the Measuring of Availability Group synchronization lag between replicas inclusive of BCP , I want to understand and learn that does ...
1
vote
1answer
156 views

Suggestions - Enabling EFS on FileStream Data for SQL Server

If anyone has already tried enabling EFS on FileStream data for multiple databases around 500 GB+, please share your thoughts on feasibility or issues / considerations we should keep in mind. We are ...
0
votes
0answers
66 views

Enabling EFS on FileStream Folders

Please help me on below: Below is my Environment: Windows Server 2012 R2 Standard SQL Server 2014 SP2 GDR Availability Groups 2014 with 3 Node (2 Sync and 1 BCP async) I have 7 Databases with ...
4
votes
1answer
357 views

How do I reclaim space in filestream data files for database in a SQL Server Availability Groups

I have a SQL 2016 Ent. Edition AG with 3 nodes. We have a database in the AG with 5 filestream tables. Each table is in it's own filestream data file. Today I fixed a bug where all of the files were ...
0
votes
1answer
61 views

Backup Structured Data and Unstructured Data seperately in SQL Server - Is it Possible?

Can I get some inputs on below: SQL Server Version : 2014 SP2 GDR with AOAG environment. Is it possible to backup Structured Data & Unstructured Data (FileStream) separately in SQL Server ? For ...
1
vote
1answer
870 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
450 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
1answer
83 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 ...
3
votes
0answers
360 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
3k 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 ...
2
votes
0answers
73 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
72 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
187 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
1answer
158 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
703 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
332 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
2answers
691 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
851 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
439 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 ...
-1
votes
1answer
339 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
34 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
584 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 ...
14
votes
2answers
1k 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 ...
0
votes
1answer
3k 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
578 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
129 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 ?
1
vote
2answers
355 views

Running out of disk space mid-restore

A colleague of mine reported that an hour after starting a restore the operation failed because the server ran out of disk space. He mentioned that since we are using filestream the size isn't ...
3
votes
1answer
2k 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
661 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
157 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
1k 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
117 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
101 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
561 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
3k 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 ...