can you post the contents of the log file which would have been generated for this job at location that you specifed. by default you can see this in C:\program...

When you run the shrinkfile

Run sp_lock <spid which is running the shrink process>

Form there take the object id and find out the table name by running.

select object_name(<object id from previous...

How much time are you waiting before cancelling it. Sometimes there is too much page arrangements going on inside which can take a lot of time. If there is no...

Are you getting error or is it just not completing. Try and see if something is blocking your process. If not then there could be many user connections against the...

Are you shrinking in smaller chunks?

Run the following script in your database

SELECT RTRIM(name) AS NameOfFile,

size/128.0 as TotalSizeInMB,

CAST(FILEPROPERTY(name, 'SpaceUsed' )AS int)/128.0 AS SpaceUsedInMB,

size/128.0 -CAST(FILEPROPERTY(name, 'SpaceUsed' )AS int)/128.0 AS AvailableSpaceInMB, filename AS PhysicalLocation

FROM dbo.sysfiles

In the output sum...

You are trying to release a huge amount of space at once. Try releasing it in smaller chunks. You can use the given script above. If it is not working...

As C_C_ said increase the size of your datafile lets say by 10 MB. Instead of releasing the entire space at once try and shrink the file in smaller chunks...

This issue has been fixed in Cumulative Update 9 for SQL Server 2005 SP3. Please refer to the KB below for more information:

http://support.microsoft.com/kb/978308

This relieves you from the hassle...