How to check backup happening or not on multiple servers.

  • Dear SSC mates,

    I want a script that I run from my monitoring server which logins into different servers using different

    credentials and different authentication type (all these details will be in a table) and check when the last full backup, diff backup and log backup happened and store the result in a table.

    All servers are not in same domain. I can go with single user credential also, if to keep simple and feasible.

    Is there any script like that? Would appreciate your help.

    Regards,

    Ganesh.

  • Check this , It will help you

    http://qa.sqlservercentral.com/scripts/T-SQL/69348/

Viewing 2 posts - 1 through 1 (of 1 total)

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