Output of the dm_db_index_physical_stats:

The output of sys.dm_db_index_physical_stats

You are in the process of removing the files currently stored as an image to a file storage location.  Until you finish this, I think you are probably wasting your...

Michael,

this is development server, so I do not think there is any activity.

It has 4 virtual processors, 2 sockets.

It is much less powerful than production.

CSName : DEV_ENV
TotalVirtualMemorySize_MB...

Michael,

Shrinking 1024 mb takes more than 8 hours. Which is out of my timeframe. So I had to terminate it.

Approximately in 1 hour it gets to 98% and stays there...

Thanks.

So you mean to move data to a new filegroup just that one table?

Because it's LOB data, isn't it's only gonna move pointer? But data itself will stay with primary...

Thanks Michael.

The code you provided works much better.

One question, if I simply stop (terminate) the execution, would that be ok?

It will not create any problems?

It seems no matter how small chunks I set, it progresses to around 98% and stucks.

Can it be because of LOB data ?

we have a huge table that takes 80% of the data. Table has image datatype column which holds pdf documents. Recently we started to offload those documents to Azure blob....

@Ant-Green thank you for the tip.

The code:

-- Shrink the mdf file. 
DBCC SHRINKFILE(N'FileName', 0, TRUNCATEONLY);
GO

After one of the replies I decided to shrink database (not file), using SSMS...

I shrank file. Not database