Insufficient disk space for EmptyFile

Posted on 2009-04-21
Last Modified: 2012-05-06
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.
Question by:nancylytle
    LVL 31

    Accepted Solution

    an advice, if you have separate file for data and indexes than let it be there as it is, good for performance.
    LVL 31

    Expert Comment

    >>Ended up not having to change the file structure.<<

    that's what I have advised for.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    What Is Threat Intelligence?

    Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.

    Performance is the key factor for any successful data integration project, knowing the type of transformation that you’re using is the first step on optimizing the SSIS flow performance, by utilizing the correct transformation or the design alternat…
    This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
    Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties
    Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.

    759 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    13 Experts available now in Live!

    Get 1:1 Help Now