2

SQL Server 2014 Std Edition

We use the built in SQL Server encryption for our db backups (sql server backup to disk) -- works great.

We would like to implement encryption for the tlog backups (which fire every 3 min)

Is this possible? Will the built in log shipping feature magically make it all happen?

We do not want to use redgate or third party tools.

Please advise how to solve, if the built in log shipping feature does not solve.

  • What tool are you using to encrypt your backups ? We use redgate and it has ability to encrypt log backups as well. – Kin Shah Nov 16 '16 at 3:35
  • @Kin Fair call. OP enhanced. – samsmith Nov 16 '16 at 5:34
  • I guess that would be possible but you have to prepare a TSQL version of logshipping and in that whenever a log backup files you have to include keyword encryption. – Shanky Nov 16 '16 at 12:07
  • @Shanky Thanks! Note that this thread concerns the native log shipping feature in SQL Server.... the wizard driven, it does the magic log shipping. – samsmith Nov 18 '16 at 23:39
  • I dont think you have option to specify backup with encryption in LS GUI – Shanky Nov 19 '16 at 4:45

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.