peteroc (11/26/2014)
Hi Jeff,I'm with you regarding the adding more disk space but It's not my decision and I have to explore the options. I also think it's complicated by the fact of the missing CI's. Do you think this could be why the space isn't being freed up?
Heaps shouldn't prevent a shrink from running. They'll slow it down most likely, but not prevent it.
Oh, and for reference, I have a job that runs once a week on my dev server - set all DBs to simple recovery, shrink logs (data files are already small)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability