Sample Header Ad - 728x90

If I am a sysadmin, does it matter if I have the MASTER KEY password or not?

0 votes
1 answer
212 views
So currently I've faced some issues restoring databases with Symmetrical keys, Master keys, SSISDB and etc and I got curious. We didn't have the password for anything. All that was done in the past, stayed there, BUT I could normally restore the DBs by regenerating password for keys, moving DBs, restoring DBs,opening the keys on source server and latest ALTER MASTER KEY ADD ENCRYPTION BY SERVICE MASTER KEY. So, if you are a sysadmin, (obviously it's a good practice) but if you lose keys, it's no trouble , since we can regenerate, right?
Asked by Racer SQL (7546 rep)
Aug 28, 2024, 12:40 PM
Last activity: Jun 25, 2025, 06:04 AM