Hi Gail,

Thanks for replying.

Yes, sorry I knew log was in different filegroup - typo.

I have a warehouse server (2k8) with limited space available on one drive.

Used 99GB out of 100GB on drive but there is actually about 90GB free space on this drive as the main data is stored on the larger 300GB drive now.

I wanted to simply shrink this 99GB mdf file without fragmentation issues and so I was thinking about the "NDF Empty" technique.

So, I went to another server which is currently offline, happens to be running 2k5, in order to test this process and hopefully then use on 2k8 server.