Sample Header Ad - 728x90

FileTable in 2016 and Transaction Log Backups larger than expected

3 votes
0 answers
64 views
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 size of the files added. Ex: 42mb file results in a 87mb tlog backup, 13mb file results in 27mb tlog backup. TlogBackups Has anyone used FileTable and noticed transaction log backups that were much larger than the files added. Files are only being added to the share. Nothing is being updated or edited between adding and taking a log backup.
Asked by Christopher Ian Stoll (31 rep)
Sep 17, 2019, 04:16 PM
Last activity: Sep 17, 2019, 04:55 PM