Get the location of the recent Backup

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by antonior0 » Get the location of the recent Backup

Get the location of the recent Backup

Rate Topic

Display Mode

Topic Options

Author

Message

antonior0

Posted Sunday, September 23, 2007 9:29 PM

Forum Newbie

Group: General Forum Members
Last Login: Monday, June 25, 2007 3:29 AM
Points: 1, Visits: 1

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

Post #401816

DavePeck

Posted Friday, February 20, 2009 10:22 AM

Grasshopper

Group: General Forum Members
Last Login: Wednesday, May 15, 2013 1:18 PM
Points: 10, Visits: 664

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.

Post #661494

« Prev Topic | Next Topic »

Permissions