Start networking and exchanging professional insights

Register now or log in to join your professional community.

Follow

What is the purpose of shrinking database?

user-image
Question added by Nasir Shah SYED , Resident Data Center Engineer , Najm for Insurance
Date Posted: 2013/11/25
Shamas Imran
by Shamas Imran , Principal Software Engineer , Soliton Technologies

Shrinking data files recovers space by moving pages of data from the end of the file to unoccupied space closer to the front of the file. When enough free space is created at the end of the file, data pages at end of the file can deallocated and returned to the file system.

More Questions Like This