Backup details

• balasach82

  SSCrazy Eights

  Points: 9653

  More actions

  February 28, 2017 at 2:10 am

  #401704

  Is there an query to get backup location, retention days, db being backedup. Am looking for an easier way to get all the backup info instead of querying multiple system objects.

• Igor Micev

  SSC-Dedicated

  Points: 33110

  More actions

  February 28, 2017 at 2:29 am

  #1930633

  Check these scripts for example 
  http://www.sqlservercentral.com/scripts/Database/133740/
  http://www.sqlservercentral.com/scripts/Backups/110733/

  Igor Micev,My blog: www.igormicev.com