Questions tagged [filetable]
The filetable tag has no usage guidance.
24 questions
0
votes
2
answers
56
views
how to divide a filetable to several filetable on several disk in sql server?
I have a dms database that use filestream. I want to distribute data to several disk based on year. How can I divide this database to several disk in sql server?
I used Partitioning technique but I ...
- 1
0
votes
2
answers
113
views
Strategy for maintenance large FileStream database in SQL Server
I have a document management system for my company to manage company documents(~2TB, 1.5 million+ rows in File table).
DB is SQL Server 2019. File are saved as FileStream BLOB in SQL Server. Files can ...
- 1
0
votes
0
answers
127
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 ...
- 1
2
votes
1
answer
377
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 ...
- 21
0
votes
1
answer
237
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
157
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?
- 103
0
votes
1
answer
229
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
63
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
468
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 ...
- 141
0
votes
1
answer
259
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 ...
- 1,497
3
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 ...
- 680
3
votes
1
answer
656
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 ...
- 31
2
votes
1
answer
826
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 ...
- 121
7
votes
2
answers
762
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 ...
- 2,239
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 ...
- 101
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 ...
- 9,698
1
vote
1
answer
7k
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
680
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? ...
- 771
3
votes
0
answers
2k
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 ...
- 131
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 ...
- 183
2
votes
2
answers
2k
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 ').
- 83
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 ...
- 83
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 ...
- 83