This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 13%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ED%3C/text%3E%3C/svg%3E)
Hi there,
Sharepoint has gone read only and the database won't expand.
The database is around 300GB but the drive has lots of spare space.
We have tried to expand the database bu got the dreadded MODIFY FILE encountered operating system error 665 error.
We have defragged the drive with SQl stopped but are still getting the same error.
SharePoint 2013
SQL 2014 Standard.
Any Ideas?
Dave
I've run Contig -a and the mdf is still in 1,700,000 fragments!
What's the quickest way of defragmenting it? Defrag was at 1% after 24 hours.
I can probably copy the file to another partition, but will progably take hours/days.
I can probably restore the file from a backup, but i'm unsure how this will affect SharePoint
Have you tried defragmenting the disk, not the database [file]?
Hi Trevorseward,
We tried defragmenting the disk (that's the one that got to 1% in 24 hours), haven't tried the file itself yet.
Wondering if we can just restore the WSS_Content files to a new partition and attach them from there, jsut don't know how much that will break SharePoint.
Dave
Yes, you're running into an NTFS limitation so restoration onto a new volume would be the approach I'd take. You should be using ReFS on the volume, if you're running an OS that supports it. Otherwise, NTFS 64k clusters.
Hi Dave, do you have any progress on this thread? Please feel free to let us know if you need further assistance.
Here is a document on OS error 665 for your reference: OS errors 1450 and 665 are reported for database data files.
And referring to the document and as Trevorseward suggests:
Consider using a ReFS which does not have the same ATTRIBUTE_LIST_ENTRY limits that NTFS presents. You must reformat the volume by using ReFS.
Hi, Would adding a new file to the Filegroup using the MSSQL SSMS help in such a case? It'd make a second mdf file in the PRIMARY group.
thanks!
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(268.8, 78%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETK%3C/text%3E%3C/svg%3E)
Hi ci7alex1,
Yes, adding a new ndf file to the filegroup resolves the issue. The impact is only on A file (example: mdf) and not on the drive and so adding another file helps to resolve.
Consider defrag after you add the file as it might take days to complete