Home Forums SQL Server 2005 Backups Script/s to check backups of all accessible SQLServer - ??? RE: Script/s to check backups of all accessible SQLServer - ???

  • If you don't mind using PS see if this helps:

    http://www.mssqltips.com/tip.asp?tip=1798

    to narrow down the jobs that do the backups you could do something like this:

    if ($instance -eq "MYINSTANCE") {$jobs=$srv.JobServer.Jobs | where {$_.Name -like "DB_BACKUP"}}

    __________________________
    Allzu viel ist ungesund...