SQL Server Base with encrypted columns

Asked

Viewed 35 times

1

I have an SQL database in which I encrypted some columns following the steps of the following explanation: https://www.devmedia.com.br/criptografia-de-dados-no-sql-server/37027

I basically created the master key, symmetric and certified chve. From what I understand, all this information is tied to the database, not the server. My question is, imagine someone steals a backup from this base of mine and climbs onto another SQL server, could that person read the database data? The certificate, symmetric key and masterkey would work on that other server?

No answers

Browser other questions tagged

You are not signed in. Login or sign up in order to post.