Backup and restore SQL Server database with encrypted columns: what should I backup along with database?
1
vote
2
answers
1522
views
Assume I've backed up a SQL Server database with Management Studio, and that database have some encrypted columns. Now I want to restore this database into another fresh-enrolled MSSQL server. To use encrypted columns I had to:
1. Create database master key;
2. Create certificate;
3. Create symmetric key.
Which of those are stored along with backup, and which I should backup manually and restore on the other server manually as well? I see there is SQL statements
backup master key
, restore master key
, backup certificate
, create certificate ... from file
. So, along with database itself, there are:
1. Master key;
2. Master key password;
3. Certificate;
4. Certificate private key;
5. Symmetric key.
So what (and how) should I deal with when I restore my database on a fresh server? Thank you!
Asked by nyan-cat
(111 rep)
Apr 9, 2021, 11:08 AM
Last activity: Apr 9, 2021, 11:50 AM
Last activity: Apr 9, 2021, 11:50 AM