Compressed vs. uncompressed sizes

lfagettilfagetti Posts: 15 Bronze 2
all SQL based commands are showing the uncompressed size.
Only way I see to check compressed size (real allocated disk space) with Db files open is to check the files properties on the drive.
Any other way?


  • Thank you for your post into the forum.

    SQL Server is totally unaware of SQL Storage Compress or HyperBac processes being performed on the database files. So SQL Server will always believe that the database file sizes are the real uncompressed sizes.

    The only to check the actual compressed file sizes is to look at the properties for the actual files.

    Many Thanks
    Eddie Davis
    Product Support Engineer
    Redgate Software Ltd
    Email: [email protected]
  • You could always use xp_cmdshell and DIR from within SQL to view the sizes of the files on disk.
Sign In or Register to comment.