Adaptive Server reads the master and dual master key encryption keys from the master key start-up file into the server memory, if:
The server is started with automatic master key access enabled, or
automatic master key access is enabled while the server is running.
If:
An automatic_startup key copy of the master or dual master key is created, Adaptive Server writes the master or dual master key encryption keys to the file.
The key encryption key of the automatic_startup key copy of the master or dual master key is altered, Adaptive Server writes the new master or dual master key encryption keys to the file.
An automatic_startup key copy is dropped, Adaptive Server deletes the corresponding record in the file.
A database is dropped, Adaptive Server deletes all records belonging to the dropped database.
A master or dual master key is dropped, Adaptive Server deletes the corresponding record.
A new master key start-up file is specified using sp_encryption mkey_startup_file, Adaptive Server synchronizes the server memory with the contents of the new file.
Once a master key encryption key is in memory, the master key can be accessed through the automatic_startup copy even if the master key password is not set.
