04-15-2007, 04:13 AM
|
#6 (permalink)
|
| Junior Member Join Date: Feb 2007 Location: Melbourne AU
Posts: 13
Rep Power: 0  | Shrink I ensure of some routine shrink process. If using MS SQL a maintenance plan can be set to run as and when required.
Transaction log files can grow VERY large yet in some cases the large file is only "white" or empty space.
Yet it is actually alloted space on the disk.
If no and no shrink occurs you can run into disk space issues.
The shrink reduces the alloted file size to what the system requires for the actual contents not what was.
The file size grows based on your activity, until truncated, yet the system holds onto it just in case..a bit like keeping an RE 6 manual just in case..
Shrink, its a good thing.. |