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

• gautamak

  SSC Rookie

  Points: 32

  More actions

  October 18, 2020 at 6:46 am

  #3798500

  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.

  GautamAK

• Site Owners

  SSC Guru

  Points: 80320

  More actions

  October 19, 2020 at 7:10 am

  #3798722

  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: 151

  More actions

  October 19, 2020 at 12:50 pm

  #3798800

  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