I am not sure if I know what I'm doing: I am trying to backup "Integration Services Catalogs", seen in the picture below.
But all the instructions I get is to backup the SSISDB database. All I am familiar with is the catalog, that's where I go to "execute" my packages.. I know executing is just running some commands/script to run SPs within SSISDB database, but 1) if I was to make a backup of SSISDB, would that also give me a full backup of the catalog too?? How so? So restoring the DB would give me back my catalog ???
If the answer is yes, why do I need to BACKUP MASTER KEY Transact-SQL statement as part of the backup procedure (according to my studies), wouldnt this just be a simple DB backup??? Thank you very much in advance
