Shrinkfile

[NormanCastle]

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?

 

[gmmastros]

How do I get the file ID number to run it as a SQL statement?

Select * From sysfiles

-George
Microsoft SQL Server MVP
My Blogs
SQLCop
"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom