I've compared the create table scripts and they are exactly the same as well the indexes. My thoughts were that something may be happening around the LOB pages, maybe the...

Can anyone help out here?

No table is not compressed I've just added the attachments 🙂

Thanks for the replies, I actually got around this by adding another databases file to the primary filegroup on a new disk with unlimited growth, then limiting the growth on...

OK Thanks for the help guys. I was exploring other options than restarting sql server as it's a production box, but it looks like that's the only option available.

After further...

No, We have 3rd party backup software which has made a backup call to SQL server, this process has been stuck in a rollback state for over a week and...