How can we help you today? How can we help you today?

Backup Details

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?
vsunkara
0

Comments

4 comments

Sort by
  • Brian Donahue
    Hello Vishnu,

    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.
    Brian Donahue
    0
  • petey
    See http://www.red-gate.com/MessageBoard/viewtopic.php?t=2241.
    petey
    0
  • vsunkara
    This is really helpful. Now I got all the information I need to do my report.
    vsunkara
    0
  • Brian Donahue
    Hello,

    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!
    Brian Donahue
    0

Add comment

Please sign in to leave a comment.