OK... well I have had some more time to look at this issue. What I did was to run a Disk Usage by Table report on 2 databases, my production database and a copy of that same database created from a SQL Compressed backup.
From my discovery the RESERVED (KB) along with the DATA(KB) increased especially with some of the larger tables.
However when I restore the database from a backup that doesn't utilize SQL Compression I have a database close to the original size of the production (original) database.
Still scratching my head! :crazy:
Kurt
Kurt W. Zimmerman
SR DBA
Lefrak Organization
New York, NY
http://www.linkedin.com/in/kurtwzimmerman