Script/s to check backups of all accessible SQLServer - ???

• newbie01.sqlserver

  SSC Veteran

  Points: 284

  More actions

  March 4, 2011 at 3:55 pm

  #246429

  Hi,

  I have a mix of SQL2000 and SQL2005 and at the moment, am checking the backups manually on each database, I mean really manually, right-click Report on backup ... :blush:

  Can someone please advise if there is any script out there somewhere in the universe that I can run to list all accessible SQLServer and then go thru each database and list the x database and transaction log backup, whether they are incremental, differential etc.

  Would be good if it outputs it into some kind of report as well.

  FYI, unfortunately, am not allowed to create a job for this so I need to run it as either a batch file maybe or as called from osql/isql. Am not the full-time DBA for the database, am just there to check the backup status.

  Any advise will be much appreciated, thanks in advance.

• Mr. Holio

  Hall of Fame

  Points: 3314

  More actions

  March 5, 2011 at 7:33 am

  #1294985

  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...