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

  • PowerShell would be great for this. Using the SQL Server Provider you can iterate over the Linked Servers of your Central Server and issue a query to each. Then you can export the results to a CSV file, or store them in a database.

    This could also be done in T-SQL using the same algorithm and some dynamic SQL.

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