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

Backup Schedules & Sizes Report Expand / Collapse
Author
Message
Posted Monday, October 27, 2008 6:22 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Wednesday, October 3, 2012 6:35 AM
Points: 97, Visits: 501
Hi, I created a crude sp that runs from a RS reports to show for a particular instance what the backup regime is - the days and frequency and the last size of the backup - we need to supply this info to our server team to manage double-take and tape backups etc. I wrote this for sql 2000. (see attachment) - now i just cannot fathom how to join the new maintenance plans to the actual backupset table as i dont seem to be able to find a database ID or name column that links..
Has anyone done anything similar? any ideas..??

exec uspBackup_Report_Data_ALL


Oraculum

  Post Attachments 
usp_backupData_report.txt (78 views, 11.98 KB)
Post #592041
Posted Friday, January 13, 2012 12:29 AM


SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Saturday, September 13, 2014 12:30 AM
Points: 27, Visits: 470
Check my published scripts. You will find where that data is stored in the script code.

Jason
http://dbace.us
Post #1235401
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse