Hello Experts. I have some 400 instances each with 30 DBs in my environment. The SQL servers are mix of 2005 and 2008. I want to design an customized SSRS report to monitor the backups happening on these DBs for all the instances and generate a report. Can you please tell me how to automate this or any quick blog which i can refer to ??? Thanks in Advance

Hi There Please have a look on the following article this will help you a lot http://www.sqlservercentral.com/articles/Backup+%2F+Restore/66564/ After that what you create email subscription for your SSRS Report to send you the status of all your back up every morning as PDF or Excel etc. If you have any question please let me know. Many Thanks Syed Qazafi Anjum Please click "Mark as Answer" if this resolves your problem or "Vote as Helpful" if you find it helpful.