Set up log shipping on TDE encrypted DB using solarwind SFTP in Sql 2019 std

  • gautamak


    Points: 12

    Hi All,

    I want to Set up log shipping on TDE encrypted database using solar wind SFTP.

    So what will be the best approach,first enable encryption on database then setup log shipping or setup log shipping first then enabled encryption on database.

    Also one more challenge using solar wind SFTP, will it work with log shipping as no shared path is available.

    I am using Sql server 2019 Std

    Thank in Advance for quick response and sharing the details for completing this.


  • Site Owners

    SSC Guru

    Points: 80372

    Thanks for posting your issue and hopefully someone will answer soon.

    This is an automated bump to increase visibility of your question.

  • Cebisa

    SSC Enthusiast

    Points: 109

    I would apply the TDE certificate first and restore it on the destination first.

    You can set the up the destination database in standby mode and create a job on the destination to restore the x log files.

    We did that with one server where we relied on a MoveIT task to copy the files.

    Let me know if you need more information

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply