Forum Discussion

Copper Contributor

Oct 05, 2022

Free Space Usage inside filegroup partitions

Hi All, in last 12 months I've used filegroup partitions based on Range Right partition scheme, based on 120 ranges assigned to 8 filegroup round robin at application level we have a DataStr...

partitioning

olafhelper

Bronze Contributor

Oct 06, 2022

I don't understand what the (real) problem is, nor how we could assist with that less on information?
Please explain it more detail.

Olaf

olafhelper
Bronze Contributor
Oct 06, 2022
And it's not only me don't understanding, what the problem is.

https://learn.microsoft.com/en-us/answers/questions/1036142/free-space-usage-inside-filegroup-partitions.html

Olaf
- dscaravaggi
  Copper Contributor
  Oct 06, 2022
  olafhelper
  as reported in https://learn.microsoft.com/en-us/answers/questions/1036142/free-space-usage-inside-filegroup-partitions.html
  I'm addressing investigation in backup infrastructure
  It is reasonable to imagine that I got missing points, and SQLServer cannot reuse allocation unit until a success backup operation.