Questions tagged [filetable]
The filetable tag has no usage guidance.
20
questions
0
votes
0answers
19 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
1answer
50 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
1answer
71 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
0answers
48 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
1answer
129 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
1answer
117 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
1answer
2k 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
1answer
604 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
1answer
690 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
2answers
622 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
2answers
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
1answer
979 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
1answer
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
1answer
5k 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
2answers
397 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
0answers
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
3answers
6k 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
2answers
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
1answer
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
1answer
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 ...
