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..?? :ermm:
exec uspBackup_Report_Data_ALL