Data file expansion fails, Hard disk space is available

  • Hi all,

    I have a huge database on development server. The primary filegroup has one file of about 3TB. The file is set to autogrowth 1MB, unrestricted. The hard disk still has 5TB free space. However, the automatic or manual file growth is failing with the below error message. I use SQL server 2008 on Windows server 2008 R2.

    Msg 5149, Level 16, State 3, Line 1

    MODIFY FILE encountered operating system error 665(The requested operation could not be completed due to a file system limitation) while attempting to expand the physical file

    I have checked http://support.microsoft.com/kb/2002606 but the error message is a little different so I am not sure if the patch applies to my scenario.

    The hard disk size is too huge for me to be able to check disk fragmentation. Please suggest.

Viewing 0 posts

You must be logged in to reply to this topic. Login to reply