2

When attempting to create a file or folder in a SQL filestream file share, Windows presents the following dialog:

filestream error

For those who cannot see the image, the error reads "The file 'New Text Document.txt' is too large for the destination file system."

The create filetable script is as follows:

SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ARITHABORT ON
GO

CREATE TABLE [dbo].[Media] AS FILETABLE ON [DboData] FILESTREAM_ON [FileStreamData]
WITH
(
FILETABLE_DIRECTORY = N'ShareName', FILETABLE_COLLATE_FILENAME =     SQL_Latin1_General_CP1_CI_AS
)
GO

This is a newly created filetable and I am unaware how to troubleshoot it. Google returns almost no relevant results.

EDIT: As it turns out, files greater than 0 bytes can be copied into the filetable without error, but renaming the file still causes the above error.

EDIT2: The error occurs whenever a file is moved. Create and Delete is successful.

0

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Browse other questions tagged or ask your own question.