1) shrink the file -- Does not reduce this value
2) restarted the server -- Resets the value to 0
3) Detach the server -- Does not change the value
4) Offline the DB -- Did not try this
Restarting/Detaching/ Taking the database offline causes a down time. I would like to know if there is a way to bring this value without causing a downtime.
Cheers...