Write to sparse file error and ndf files

• SQL Bandit

  SSCommitted

  Points: 1757

  More actions

  August 23, 2020 at 8:27 am

  #3782635

  Hi,

  We have ABC.mdf and ABC2.ndf and a relatively newly created ABC3.ndf

  We created ABC3.ndf because ABC2.ndf  was on a 2TB drive and was running out of diskspace.

  The drive ABC2.ndf  is on is pretty much full now.

  We are seeing Write a sparse file errors (17053 and 5128) saying there is a lack of diskspace for ABC2.ndf  (which is true)

  ABC3.ndf is growing. And ABC.mdf and ABC2.ndf and ABC3.ndf are all on the same filegroup.

  Is this normal to get not enough diskspace errors against ABC2.ndf , when there is an ABC3.ndf file?

• Site Owners

  SSC Guru

  Points: 80330

  More actions

  August 24, 2020 at 9:10 am

  #3782842

  Thanks for posting your issue and hopefully someone will answer soon.

  This is an automated bump to increase visibility of your question.