June 6, 2019 at 9:39 am
I am needing to restore / rebuild an SSIS Catalog on a new SQL Server. Problem is, I don't have a backup and only have the MDF and LDF file. I am unfamiliar with SSIS so I have tried attaching the DB but it doesn't re-create the catalog and the jobs.
I know the password to the SSISDB. What steps can I do for me to be able to restore? I am thinking of the following but unsure whether it is the way to go:
I have done the above steps successfully for the msdb system database so I would like to know if it will also work for the SSISDB. If not, what steps do you recommend? Additionally, is there another way for me to re-locate where the SSISDB will be stored aside from the C: drive?
June 6, 2019 at 2:20 pm
Do you have the Master Key from the original server? That is, the key used to encrypt (some of) the data inside SSISDB?
June 6, 2019 at 2:22 pm
Note also that SSISDB does not contain any jobs, merely packages, logs, environments and configurations.
June 7, 2019 at 1:29 am
Is the master key different from the password? I have the password but I'm not sure if it's the master key.
Yes you're right, I have the SQL jobs already from the MSDB, what I meant was I need to get the packages inside the SSISDB and basically build the SSIS Catalog, since the work of the SQL Jobs are to run the packages inside it.
I only have the MDF and LDF files though.
June 7, 2019 at 7:47 am
Nevermind, I was able to solve my problem. However I didn't do it via the MDF and LDF but rather I was able to find a copy of the old project files. I just re-deployed the project to a new SSIS catalog in the new environment
Viewing 5 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply