Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Get the location of the recent Backup Expand / Collapse
Author
Message
Posted Sunday, September 23, 2007 9:29 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum 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
Posted Friday, February 20, 2009 10:22 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Yesterday @ 9:33 AM
Points: 17, Visits: 834
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 »

Add to briefcase

Permissions Expand / Collapse