OTHER - backup size on disk vs backup size in gui (4222995)

Tthe backup size reported in the SQL native restore GUI is not the size of the compressed backup taken by LiteSpeed for SQL Server. How to determine the true size of the backup files created by LiteSpeed for SQL Server?

N/A

Note: The correct values, in an easy to read format are displayed in the LiteSpeed Console. Highlight the Database (on the left) and select 'LiteSpeed Activity (on the right).

WORKAROUND:
use msdb
go
SELECT physical_device_name, backup_size, first_lsn,last_lsn,backup_start_date, backup_finish_date, database_name
FROM backupset bs, backupmediafamily bf
WHERE bs.media_set_id = bf.media_set_id
AND backup_start_date >'2012-10-11 06:30:03.000'
AND database_name LIKE'Adventureworks'
ORDERBY backup_start_date DESC

-- to see the size of the database
sp_databases

-- to see the size of the backup with compression (this will also show the database size)
select*from LiteSpeedActivity where StartTime >'2012-10-11 06:30:03.000'and databaseID = 7

The following table defines the values of Bytes, Kilobytes, Megabytes, and Gigabytes.