log shipping sync check_report_HTML_format

• manu.manohar033

  Old Hand

  Points: 328

  More actions

  December 15, 2017 at 1:03 am

  #342060

  I want script, for execute the script it will show the backup, copy and restore last lsn in HMTL format.

• Ant-Green

  SSC Guru

  Points: 113507

  More actions

  December 15, 2017 at 1:42 am

  #1972254

  Hi Manu

  I suggest reading through https://docs.microsoft.com/en-us/sql/database-engine/log-shipping/monitor-log-shipping-transact-sql once you have got the query to display the information you require, you can then code it in an email to be sent as HTML.