Log Shipping File Sizes

• peteroc

  SSChasing Mays

  Points: 638

  More actions

  February 12, 2015 at 5:41 pm

  #294679

  Is there any way to return the details (filename, size, data and time copied) of the files that are copied during the log shipping process? I'd like to insert these details in a table so I can report on them.

  Thanks,

  Peter

• vecerda

  SSCrazy

  Points: 2532

  More actions

  February 15, 2015 at 6:55 am

  #1777718

  I believe that this query will get you started:

  SELECT * FROM dbo.log_shipping_monitor_primary

  you would alter it for secondary if needed.

  This will get you the file name and the date. I don't think that there is anything that stores the file size.

  Petr