• 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