DuncEduardo (4/2/2013)
ok thanks Gail - just one last thing however - failed to mention that I have already shrunk the mdf.Will the action you suggest work ok in this scenario?
Yes.
I guess it's my narrow understanding of what the original emptyfile command from mdf to ndf actually does, i.e. does it "copy" or "cut" the data?
From Books Online
EMPTYFILE
Migrates all data from the specified file to other files in the same filegroup.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability