March 1, 2016 at 11:05 pm
HI All,
I have a SQL file table which is created in a single File Stream Group. There are multiple files which belong
to this file group. Each file pointing to a new mount point or lun on the SAN.
The problem I am facing is that some of the older mount point volumes are full hence I have created new data containers on the same file group linked to new files and mount points.
When BLOB data written, it is still trying to write to the old data containers which are full and the following errors
are generated.
DESCRIPTION:The operating system returned the error '0xc000007f(An operation failed because the disk was full.)' while attempting 'NtCreateFile' on 'E:\DBData\PRD01\Data\HPSQL_RS3_L1\Ignition\fFSIgnition13\a7515d2d-c48f-4b77-a2c6-439802b65568\84e4f098-b6f3-4bf1-a2b3-f537e327180a\00009c13-0000226e-0002' at 'fsdohdlr.cpp'(1311).
How do I stop this from occurring? Any assistance will be greatly appreciated.
Thanks Ashal
March 3, 2016 at 1:06 pm
Set the filegroup to read-only?
March 7, 2016 at 5:10 am
HI,
The document table that is being written to lives in this file group setting it to read-only will not allow to write data to this table.
It is quite bizarre that if you your are unable to increase the size of mount points for FileStream Data containers, adding additional files to new mount points
should of worked. Although this looks that is not the case.
Can someone confirm this for me?
Thanks Ashal
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply