Resurrecting this thread since this is where my quest started. . .
I have been successfully rebuilding my database design (I think). I say I think because as I have been creating the new design, I have been building as I go, and - I have noticed something a little concerning. My new files in my Filegroups are growing just fine, but my main .MDF file is not shrinking. Now - I have done a couple of things to see if perhaps the disk space usage is just not being reported correctly, but thus far - no changes:
- Ran DBCC CHECKDB against the database in question - no issues there.
- Ran DBCC UPDATEUSAGE to see if perhaps this wasn't needed after all the moving of data to new files/Filegroups, but again - no change.
- Backed up and restored the copy of the database, but again - no change.
- Started from scratch with a backup of the current database in our PROD environment. Ran my scripting to the point I am at, but again - no change.
There should be a current difference of nearly 30gb of data that has been redistributed to the new files/Filegroups, but my main .MDF is still the same size.
I've tried researching this, but the only things I could find were the ideas that I have tried to date (listed above).
Any insight into this would be really appreciated. This is currently being constructed on a 2008 R2 SQL Server Developer Edition install, but will eventually be in a Standard Edition Version of the environment (all of which are 64-bit if that make any difference).
Thank you all in advance!