Compression Speed

• 
  The backup speed is stored in the logical_device_name column in the msdb..backupmediafamily table. Could you pls post the contents of one of these columns for a backup that was performed using SQL Backup?
  
  e.g. to retrieve the value for the latest backup of the pubs database
  

  SELECT TOP 1 a.logical_device_name FROM msdb..backupmediafamily a
  INNER JOIN msdb..backupset b ON a.media_set_id = b.media_set_id
  WHERE b.database_name = 'pubs'
  ORDER BY b.backup_start_date DESC
  

  If the value is empty, could you pls check the contents of the log file to see if there were any warnings? By default, the log files are stored in <system drive>:\Documents and Settings\All Users\Application Data\Red Gate\SQL Backup\Log\<instance name>

  petey April 10, 2007 21:25

  - 0 +
• 
  Here is the value of logical_device_name for a backup:
  Red Gate SQL Backup (4.6.0.815):0000001C26A6000000000006797080000000000000001B6D0203
  
  The report for that same backup was mailed to me and had this information:
  BACKUP DATABASE successfully processed 14758649 pages in 7020.288 seconds (17.221 MB/sec).
  It came as a success, without warnings.
  The exact same information is in the log file.
  
  In the GUI the compression speed is reported as 0.

  mf April 11, 2007 01:09

  - 0 +
• 
  Could you pls download a patched command line version of SQL Backup from http://www.yohz.com/downloads/SQLBackupC.zip, and try backing up a test database to see if the speed is recorded correctly? Thanks.

  petey April 12, 2007 06:29

  - 0 +
• 
  Yup, patched version worked...

  mf April 12, 2007 06:37

  - 0 +

Add comment

Please sign in to leave a comment.