• 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)