I'm having problems with Shrinkfile. I wish to use the option to migrate the data to other files, and then delete the file.

It takes several hours to operate a single shrink operation. And then it usually gives an error message. It only works sometimes.

Any ideas what could be wrong?

I am, by the way, using SQL Server management Studio. How do I get the file ID number to run it as a SQL statement?