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.