muthyala_51 (1/22/2014)
Perry Whittle (1/21/2014)
What steps have you taken so far?I used the command COMPACT /C /S source destination to compress all the read file groups. It worked fine. But I need to know how safe is this.
It's standard NTFS folder\file compression and has been available in Windows server since Windows 2000.
muthyala_51 (1/22/2014)
Also the statement in the article says The execution time of these statements will be slower than equivalent statements on noncompressed filegroups.
That is correct. You have the overhead in the OS to uncompress the data before it is read.
You also stated that you didnt see any difference in file size on your test, can you supply more details on the volume and the file itself?
What was the exact output for the command
COMPACT /C /S
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉