I wonder if someone can help?
I was attempting to move contents of mdf to a secondary data file ndf but this failed about 20% through the process with the error "cannot move all contents of file .... using emptyfile command"
Command was: dbcc shrinkfile(1,emptyfile).
There are 3 files in same filegroup MDF, LDF and newly created NDF.
I created NDF on separate drive as this had plenty of space
MDF was around 5GB with almost 5GB free space.
When the process failed, around 1GB of data was "emptied" to NDF.
My question is this: the original MDF is still showing 5GB. Can I simply remove the NDF and try another method on MDF, i.e. SHRINKFILE (1, 100)
Someone suggested installing SP3 on 2k5 but I'm not in a position to do this nor is it advisable due to some applications running off this server.
So, I just wish to shrink MDF and avoid the NDF method but I don't want to lose any data with this incomplete process.
My original plan was:
b)empty mdf using shrinkfile/emptyfile
d)empty ndf to move data back to mdf