Questions tagged [filetable]
The filetable tag has no usage guidance.
23
questions
0
votes
0
answers
68
views
Unable to get FileStream Length with After Insert trigger
I asked this question on StackOverlow, but it mostly received comments about the use of variables and no answer. I program mainly in VB.Net, so my T-SQL knowledge is limited. The reason I'm populating ...
2
votes
1
answer
97
views
MS SQL attach MDF/LDF without FileTable folder
Is it possible to attach a DB that had a FileTable w/o the FileTable files?
We were hit with ransomware and the image files are corrupt but the mdf/ldf are fine. I can lose the images, but I really ...
0
votes
0
answers
35
views
Has anyone used a Windows Failover Cluster with SQL Server FILESTREAM FileTables and experienced any major issues?
Has anyone used a Windows Failover Cluster with FileTables and experienced any major issues?
We're doing a proof of concept of this architecture with Windows Server 2019, SQL Server 2019 Standard ...
0
votes
1
answer
40
views
change file table file stream data folder faces error The container can not be dropped
I want to change file database file stream folder from Drive D to Drive F. I successfully transferred data to new folder but when I want to Remove old file stream folder I face this error:
"The ...
0
votes
1
answer
98
views
Wrong result for FileTableRootPath Function of SQL Server
I just restored a database backup and now the result of the function FileTableRootPath() is incorrect.
Where is the place that I can change to change the result of this function?
0
votes
1
answer
114
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 ...
3
votes
0
answers
55
views
FileTable in 2016 and Transaction Log Backups larger than expected
I am testing using FileTable in SQL Server 2016 to store files of different sizes (could be pdf documents sized around 1mb to video files that are 200mb).
When adding a file to the FileTable, I take ...
3
votes
1
answer
245
views
MS SQL FileTable CreatedBy and LastModifiedBy
When using a SQL FileTable table, I would like to store additional metadata for the file such as CreatedBy and LastModifiedBy. By looking at SQL File Table Schema, this information is not available by ...
0
votes
1
answer
171
views
Quality Control: Check file names in a folder against filenames in a table
I have a records system in an Oracle database. The records system is used to retrieve pdf, jpeg, video documents, etc.
The design is quite simple: there is a table called infrastructure_records that ...
4
votes
2
answers
3k
views
SQL SERVER FileTable/FILESTREAM share suddenly becomes unavailable
We had difficulty setting up a FileTable share on a SQL 2014 instance and after giving up on trying to name it after our instance name, we left the name of the share as mssqlserver, but it finally ...
3
votes
1
answer
619
views
Database for store images
Actualy I'm using MongoDB with embedded images next to other data in same documents.
Images count actualy are more than 14000 and each image size is less than 1MB. Images are readed frequently and ...
2
votes
1
answer
745
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 ...
7
votes
2
answers
689
views
Restore database with a FileTable
We have a SQL Server 2014 (build 12.0.24457.0) database with two tables in, both are FileStream tables, the biggest has 2979466 rows, SUM(cached_file_size)= 40564905472.
We have tried to restore this ...
4
votes
2
answers
2k
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 ...
5
votes
1
answer
1k
views
How can I return the full text of a document indexed in SQL Server Full-Text?
I'm using SQL Server 2014 with FileTables to store a large number of documents in different formats. The iFilters are working great, and everything is getting indexed with FTS + Semantic Search. Now ...
0
votes
1
answer
3k
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 ...
1
vote
1
answer
6k
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
2
answers
444
views
Where/how does innodb store tables in files?
I read somewhere that InnoDB can store all the tables in a single file or in separate files. Is this a configuration option? What is the default setting? A file for all tables or a file per table? ...
3
votes
0
answers
1k
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 ...
6
votes
3
answers
7k
views
Is SQL Server's FILETABLE suitable for storing large files (bigger than 10 GB)?
There is a project for lab. The requirement to save the lab data (raw data and related infomation ) for research for years.
So the data must be saved for years, but the data is so big, every raw ...
2
votes
2
answers
1k
views
Error deleting FileTable - HRESULT = '0x80070490'
When trying to delete a FileTable, the following error occurs:
Message 33405, Level 16, State 7, Line 1
Error during operation on an object table Discard FileTable. (HRESULT = '0 x80070490 ').
2
votes
1
answer
3k
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 enabled ...
3
votes
1
answer
2k
views
Backup and restore FileTable files
I'm preparing to use the FileTable feature in SQL Server 2012, but I'm unclear about how backups work with this feature:
Does a full database backup include FileTable files?
How would I perform the ...