SQL Server – Where Does It Store Symmetric Keys?

filegroupssql serversql-server-2016symmetric-keyt-sql

I am wondering if symmetric keys created in particular database are being stored in the primary file group?

Or they are stored in some special file group which the user is not able to interact with?

For example, if I am performing a partial backup to a file group (primary or secondary) can I be sure that the backup does not contain the symmetric keys?

Best Answer

The underlying system tables used by the sys.symmetric_keys catalog view are stored on the PRIMARY filegroup along with other database meta-data.