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