Get the location of the recent Backup

• antonior0

  SSC Rookie

  Points: 29

  More actions

  September 23, 2007 at 9:29 pm

  #181351

  Comments posted to this topic are about the item Get the location of the recent Backup

• DavePeck

  SSC Enthusiast

  Points: 143

  More actions

  February 20, 2009 at 10:22 am

  #947673

  As the stored procedure is written, only backup sets with names are returned.

  To return data for all databases except tempdb, the WHERE clause should be:

  WHERE k.database_name <> 'tempdb'

  Also, the @Days parameter isn't used in the stored procedure as posted. @Days can be eliminated from the script.