• State Verified Answer
  • Locked Locked
  • Replies 2 replies
  • Subscribers 12 subscribers
  • Views 3896 views
  • Users 0 members are here
Options
Related
This discussion has been locked.
You can no longer post new replies to this discussion. If you have a question you can start a new discussion

How to specify a server certificate when taking an encrypted full backup?

Cagdas
over 4 years ago

How do I specify a server certificate when taking an encrypted full backup using LiteSpeed? (see "SERVER CERTIFICATE" option below)

--Encryption Options ENCRYPTION (ALGORITHM = { AES_128 | AES_192 | AES_256 | TRIPLE_DES_3KEY } , encryptor_options ) <encryptor_options> ::= SERVER CERTIFICATE = Encryptor_Name | SERVER ASYMMETRIC KEY = Encryptor_Name

https://docs.microsoft.com/en-us/sql/t-sql/statements/backup-transact-sql?view=sql-server-2017

  • 0 over 4 years ago

    Hello,

    Are you trying to use SQL encryption on a Litespeed formatted backup file (instead of Litespeed's encryption)?

    Thanks

    -Ben-

  • +1 over 4 years ago in reply to ben

    Perhaps a better question would be...


    Are your trying to use SQL encryption methods with Litespeed's stored procedures?

    If so, please note Litespeed's stored procedures do not support SQL encryption methods.

    However we do provide encryption within LItespeeds code.

    Example levels offered:

    0—40-bit RC2

    1—56 bit RC2

    2—112 bit RC2

    3—128 bit RC2

    4—168 bit 3DES

    5—128 bit RC4

    6—128 bit AES

    7—192 bit AES

    8—256 bit AES

    9—MS_AES_128

    10—MS_AES_192

    11—MS_AES_256

    Hope that helps,

    -Ben-