• manu.manohar033 - Friday, December 15, 2017 1:07 AM

    Hi,

    I want to know with script, Hourly log backup size in log shipping. Hourly and daily basis.

    Welcome to SSC Manu,

    Please take a look at MSDB tables, primarily backupset, and the other logshipping tables, that will give you the information you need.

    If you get stuck please post back with the query you have generated along with what is not working for you specifically.