Learn how to a build a cloud-first strategyRegister Now

  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2287
  • Last Modified:

Insufficient disk space for EmptyFile

I am working with a SQL Server 2005 workgroup edition database of about 37 gbs.  It has 2 filegroups Each filegroup contains one datafile, one index file and one log file.  This was set up long before I joined the company.
We are now updating the hardware, including drives and I would like to rearrange what is placed where on the drives.
I feel the easiest way to do this would be to get everything into 1 file (one for data/indexes and 1 for log) and then to look at what is accessed most frequently and created files and filegroups on different disks after I have the information about usage.
However, this is my first time to do something like this and I could use some advice or solutions on how best to do this.
Right now when I try and do a Shrink file empty file, I get an error message:
There is insufficient space in the filegroup to complete the emptyfile operation.
I increased the file sizes to accomodate the additional data, but still get the error.
Any assistance, advice welcome.
  • 2
1 Solution
an advice, if you have separate file for data and indexes than let it be there as it is, good for performance.
>>Ended up not having to change the file structure.<<

that's what I have advised for.

Featured Post

New feature and membership benefit!

New feature! Upgrade and increase expert visibility of your issues with Priority Questions.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now