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
Last activity: Jun 25, 2025, 06:04 AM