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
Right there with Babe

Right there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with Babe

Group: General Forum Members
Last Login: Thursday, April 16, 2015 4:43 PM
Points: 750, Visits: 1,874
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 @ 3:35 AM
Points: 15,047, Visits: 29,232
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 Query Performance Tuning
and
SQL Server Execution Plans

Product Evangelist for Red Gate Software
Post #1345274
Posted Wednesday, August 15, 2012 12:34 PM
Right there with Babe

Right there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with Babe

Group: General Forum Members
Last Login: Thursday, April 16, 2015 4:43 PM
Points: 750, Visits: 1,874
I'll check them both out.

Thanks Grant.



Post #1345461
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse