Home Forums SQL Server 2008 T-SQL (SS2K8) Need a backup script to get backup history status for the latest backup from all linked sql servers RE: Need a backup script to get backup history status for the latest backup from all linked sql servers

  • faisalfarouqi (1/29/2013)


    Thanks. to all you guys.

    I've finally come up with a script that does the trick for me, and can be helpful for others as well. Now, here are the problems which I am facing...currently I just want to have the differential backups to be specified only if there is one on the server in the report, and it shouldn't print out diff backups in the report if there isn't any. Secondly, I want the report to be nicely formatted, so it looks good to the eyes, anything in html would do for me.

    I've attached the script with this post, and I hope now people can actually provide me with some inputs on how to achieve it in a more neat & tidy manner. You can run this in your environment, and can modify the code to suit my needs mentioned above. Pls. revert this to me, as I am in need to get this formatted, and avoid those differentials & log backups if they aren't really there.

    --Pls. note I've also attached how the report looks when it arrives in your mail box.

    I hope this helps, and now you guys can make me achieve this in a better way.

    Regards,

    Faisal

    Hi, thank you for sharing the script. I must be honest to you, I would not choose for your approach, but there may be people who would. I will propbably use the SQL Overview solution for this. Check the link you may find it interesting http://www.sqlservercentral.com/articles/Administration/63042/.