I shrank data file in a production database . at first the size was 99 GB , after shrinking it went down to 87% but 1 hour later it went back to 99 GB .
Why does this happen ?
can I fix this by performing restart ?
or it could be due to index fragmentation but is it possible to get fragmented that big ?
I know shrinking data file is not a good practice but i need to shrink it until i get more disk space
Your feedback is much appreciated