Database Administrators Stack Exchange
Database Administrators Stack Exchange

Questions tagged [filetable]

24 questions
7
votes
2 answers

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 database on to our test server, but it takes…
Henrik Staun Poulsen
  • 2,249
  • 2
  • 23
  • 41
6
votes
3 answers

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 data is more than 10 GB. If we store the raw data in…
huoxudong125
  • 183
  • 1
  • 6
5
votes
1 answer

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 I'd like to run some additional processing on the…
iivel
  • 101
  • 4
4
votes
2 answers

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 stored in my database. Today the system saves the PDF…
Junior Thurler
  • 43
  • 3
3
votes
0 answers

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 now about 60GB. Twice in the past six months, I've…
dansan
  • 131
  • 4
3
votes
1 answer

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 restore of a single file, for example?
Camila Reis
  • 83
  • 1
  • 7
3
votes
0 answers

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 a trans backup and it is always around 2x the…
Christopher Ian Stoll
  • 31
  • 2
3
votes
1 answer

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 default. I am wondering if it's possible to…
Henrique Zacchi
  • 141
  • 3
3
votes
2 answers

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 came online, online meaning if you right click in…
Eric Swiggum
  • 694
  • 1
  • 12
  • 31
3
votes
1 answer

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 updated rarely. I want to separate images from data…
cuarti
  • 31
  • 2
2
votes
2 answers

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 ').
Camila Reis
  • 83
  • 1
  • 7
2
votes
1 answer

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 or not you have the permissions for it." Already…
Camila Reis
  • 83
  • 1
  • 7
2
votes
1 answer

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 need to get the DB back. I have googled all around…
Mike Grove
  • 21
  • 1
2
votes
1 answer

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 consider to time that number of the images pass a…
n.y
  • 121
  • 5
1
vote
1 answer

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 path_locator for subtable given by something like '/subtable1/subtable1.1' ? I…
Vasilly.Prokopyev
  • 195
  • 1
  • 8
1
2