Post reply

Monitoring Backups !!

  • May 23, 2016 at 6:29 am

    #307846

    I am trying to monitor backups for all my remote servers/instances/databases from my machine.

    i want to run some script on my desktop which will fetch me information from all the instances/databases on network and give me in excel format or any format last backup information (successful or fail)

  • May 23, 2016 at 8:55 am

    #1880793

    How many servers do you need to report on and are all backups stored in a common area?

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

  • May 23, 2016 at 9:42 am

    #1880822

    35 servers, 42 instances on those 35 servers, 84 database on those 42 instances.

    All servers are on virtual environment (vmware)

    all backups store in SAN drive (LUN) D:\drive for all of them.

  • May 23, 2016 at 4:44 pm

    #1880908

    rk1980factor (5/23/2016)

    35 servers, 42 instances on those 35 servers, 84 database on those 42 instances.

    All servers are on virtual environment (vmware)

    all backups store in SAN drive (LUN) D:\drive for all of them.

    It may sound a bit like an over simplification but I'd probably start with a DOS search for *.BAK and *.TRN files (*.DIF if you have those, as well) and just grab the name of the latest of each group for each database.

    I've not personally tried it (finally upgraded over the weekend) but registering all of the servers\instances in SSMS and then using CMS to interrogate MSDB might also do the trick.

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

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

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