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

Script/s to check backups of all accessible SQLServer - ??? Expand / Collapse
Author
Message
Posted Friday, March 4, 2011 3:55 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Sunday, May 13, 2012 10:02 AM
Points: 4, Visits: 64
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 ...

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.


Post #1073612
Posted Saturday, March 5, 2011 7:33 AM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Friday, June 6, 2014 2:18 PM
Points: 843, Visits: 2,559
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...
Post #1073701
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse