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

Master Backup Report? Expand / Collapse
Author
Message
Posted Tuesday, August 14, 2012 10:44 AM
Say Hey Kid

Say Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey Kid

Group: General Forum Members
Last Login: Wednesday, July 9, 2014 7:44 AM
Points: 701, Visits: 1,731
My problem is that I have many different SQL servers and would like to have report emailed to me every morning showing if last nights backups were succussful or not.

I need something that can work across many servers and versions (2005, 2008, 2008r2).

Is there any canned software out there that can check many different servers and report on backup status?

Is there any online guides on how I can create something like the above using SSRS?



Post #1344876
Posted Wednesday, August 15, 2012 7:49 AM


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Today @ 12:27 PM
Points: 15,541, Visits: 27,919
You might want to take a look at Central Management Servers. It's a way to control & report back on multiple servers from a single location. Here's the BOL entry: http://msdn.microsoft.com/en-us/library/bb895144.aspx

I wrote an article about this over on Simple-Talk.

If all this is too much work, my company, Red Gate Software, does sell a backup management tool, SQL Backup. Not only does it manage all your backups from a central point, but you get automated testing, compression (better than Native) and a bunch of other utilities built in. There's a free eval period.



----------------------------------------------------
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood..." Theodore Roosevelt
The Scary DBA
Author of: SQL Server 2012 Query Performance Tuning
SQL Server 2008 Query Performance Tuning Distilled
and
SQL Server Execution Plans

Product Evangelist for Red Gate Software
Post #1345274
Posted Wednesday, August 15, 2012 12:34 PM
Say Hey Kid

Say Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey Kid

Group: General Forum Members
Last Login: Wednesday, July 9, 2014 7:44 AM
Points: 701, Visits: 1,731
I'll check them both out.

Thanks Grant.



Post #1345461
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse