Backup Details
vsunkara
Posts: 3
I am trying to do a report which shows the Compressed size of the database and times.
Where can I get the compressed size of the file?
Where can I get the compressed size of the file?
Vishnu Sunkara
Comments
This information is saved into the backup history in the MSDB system database. When you look at the database in the SQL Backup management console, you can see this information in the 'compressed size' column.
SQL Backup Consultant Developer
Associate, Yohz Software
Beyond compression - SQL Backup goodies under the hood, updated for version 8
That other post was actually the SQL code that I had stolen from SQL Profiler that SQL Backup uses to populate the GUI grid that I mentioned earlier. I totally forgot about that!