• SQL Galaxy - Friday, May 5, 2017 7:16 AM

    I will disable custom TLOG backup in Principal database server during configuration of log shipping.

    No!
    Do not disable the backup job created by the log shipping configuration, remove the database backup from any other jobs that may run apart from the configured job.

    SQL Galaxy - Friday, May 5, 2017 7:16 AM


    Does Log shipping technique will take of LDF growth size? So normal TLOG backup will truncate unused log space in LDF file and reuse it again,  that will be managed log growth rate. Please suggest.

    Log truncation on the Log shipping Primary will be handled by the Log shipping configured log backup job.

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉