Compression size or Actual size?

Compresses, encrypts, secures and monitors SQL Server backups.

Moderators: JonathanWatts, Chris Auckland, eddie davis, Colin Millerchip, Brian Harris, james.billings, RBA, petey

Compression size or Actual size?

Postby SQL_ME_RICH » Mon Jul 09, 2012 7:24 pm

I noticed just recently that if you right click on a completed backup job that is not using compression (like a Transaction Log), the 'Properties' dialog box shows the file size, and then a compressed size, but when you go out into the main window again - it shows the compressed size from the dialog box as being the 'Uncompressed Size'.

Am I reading this wrong, or is there something displaying incorrectly here?

This is in version 7.1.
SQL_ME_RICH
 
Posts: 64
Joined: Tue May 08, 2012 10:41 pm

Postby Marianne » Tue Jul 10, 2012 5:08 pm

Hi

Many thanks for your feedback. The 'Compressed Size' column in the Backup Properties dialog shows the size of the backup file (whether it was compressed or uncompressed). The column label will be changed in the next version to reflect this.

Cheers,

Marianne
Marianne Crowder
Red Gate Software Limited
Marianne
 
Posts: 45
Joined: Mon Oct 03, 2011 3:24 pm

Re:

Postby SQL_ME_RICH » Tue Jul 10, 2012 7:09 pm

Marianne wrote:Hi

Many thanks for your feedback. The 'Compressed Size' column in the Backup Properties dialog shows the size of the backup file (whether it was compressed or uncompressed). The column label will be changed in the next version to reflect this.

Cheers,

Marianne


Marianne, thank you for this information, but just out of curiosity then - what is this other file size in the Properties box? Is it just an errant calc?
SQL_ME_RICH
 
Posts: 64
Joined: Tue May 08, 2012 10:41 pm

Postby Marianne » Wed Jul 11, 2012 1:46 pm

Hi,

The File Size column refers to the size of the database files (.mdf, .ndf and .ldf) on disk. We will change the column labels in the next version to make this clearer.

Cheers,

Marianne
Marianne Crowder
Red Gate Software Limited
Marianne
 
Posts: 45
Joined: Mon Oct 03, 2011 3:24 pm


Return to SQL Backup 7

Who is online

Users browsing this forum: No registered users and 0 guests