Master Backup Report?

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » Backups » Master Backup Report?

Master Backup Report?

Rate Topic

Display Mode

Topic Options

Author

Message

krypto69

Posted Tuesday, August 14, 2012 10:44 AM

SSChasing Mays

Group: General Forum Members
Last Login: Friday, May 10, 2013 12:01 PM
Points: 620, Visits: 1,544

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

Grant Fritchey

Posted Wednesday, August 15, 2012 7:49 AM

SSChampion

Group: General Forum Members
Last Login: Yesterday @ 4:50 AM
Points: 13,371, Visits: 25,143

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

krypto69

Posted Wednesday, August 15, 2012 12:34 PM

SSChasing Mays

Group: General Forum Members
Last Login: Friday, May 10, 2013 12:01 PM
Points: 620, Visits: 1,544

I'll check them both out.

Thanks Grant.

Post #1345461

« Prev Topic | Next Topic »

Permissions