1. My Initial DB
size is 6.622070312 GB,
Truncation to most of table size reduced to 2.16638671875 GB.
Note:- Whereas i am seein report
of Disk Usage by Top table On truncated Table DB. I am Summing Data (KB) + Indexes (KB) = 0.026252747 GB
is why the size is 2.16638671875 GB after Truncation which is still very very high. Whereas .LDF file is considerable reduced to 1 MB