How to check last full backup status and size for over 300 databases in over 150 sql servers

• yan-160997

  Ten Centuries

  Points: 1179

  More actions

  October 19, 2011 at 8:26 am

  #259010

  Hi DBAs,

  I want to build a routine daily task to check the last database back up (e.g last night) status (successuful or fail) and the backup file sizes for over 300 databases in over 150 sql servers.

  Is there any simple way to collect the information and automatically put them to a file, e.g excel spreadsheet. I think that this is a comman task for DBAs.

  Thank you

  Yan

• SkyBVI

  SSCoach

  Points: 15128

  More actions

  October 19, 2011 at 8:47 am

  #1396684

  Hi,

  You can create a SSIS project with execute SQL task having the query to get the db name, last backup sizes, time, where it is backed up etc.

  Then result into a excel destination.

  Run this SSIS project with sql server agent jobs and schedule every night.

  Regards,

  Sushant

  Regards
  Sushant Kumar
  MCTS,MCP