Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It only takes a minute to sign up.
Sign up to join this community
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?
The underlying system tables used by the sys.symmetric_keys catalog view are stored on the PRIMARY filegroup along with other database meta-data.
