Get the location of the recent Backup

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

  • 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.

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply