Need a backup script to get backup history status for the latest backup from all linked sql servers

  • Hi Guys,

    I am actually in need of a t-sql or a powershell script that will help me get the latest backup of all sql servers from a central server. We already have our environment setup for this i.e one central server and there are quite a handful of linked servers. I would like to have a script which will scan all of these linked servers get the info back, and send me a report of the latest backup details either in an "HTML" format or possibly using some sort of tabular formatting so that it looks good. I know that many of them might have implemented this in their environment, but this is the need of the hour for me. You can get back to me either providing a comment below or sending a private e-mail on this id faisalfarouqi@gmail.com.

    I hope to see a quick response from you experts.

    I am not a good programmer by any means as I have almost started off my career in "Sql Server", and would really appreciate your help.

    Regards,

    Faisal[/b][/font]

  • Duplicate post:

    http://www.sqlservercentral.com/Forums/Topic1407742-392-1.aspx

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

  • Thanks. for pointing that out, but I may have ended up requesting this accidently. Is there any option to delete this post from this section?

    Regards,

    Faisal Farouqi

  • faisalfarouqi (1/19/2013)


    Thanks. for pointing that out, but I may have ended up requesting this accidently. Is there any option to delete this post from this section?

    Regards,

    Faisal Farouqi

    Nope.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply