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.
Nancy
nancylytleAsked:
Who is Participating?
 
RiteshShahConnect With a Mentor Commented:
an advice, if you have separate file for data and indexes than let it be there as it is, good for performance.
0
 
RiteshShahCommented:
>>Ended up not having to change the file structure.<<


that's what I have advised for.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.