Recreating SSISDB

• tmmutsetse

  Hall of Fame

  Points: 3669

  More actions

  November 15, 2018 at 3:35 am

  #376430

  Hi
  Is it possible to drop and recreate SSISDB database.My collegue restored SSISDB to a new server and now all the packages are not running.I am thinking of dropping the DB ,recreate and then redeploy packages.

  Thanks

  T.

• Thom A

  SSC Guru

  Points: 99126

  More actions

  November 15, 2018 at 4:59 am

  #2013623

  You can back up and restore an SSISDB, yes. Did you restore the key as well? You say the packages don't run, what errors did you get?

  Thom~

  Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
  Larnu.uk

• Phil Parkin

  SSC Guru

  Points: 246723

  More actions

  November 15, 2018 at 5:31 am

  #2013626

  tmmutsetse - Thursday, November 15, 2018 3:35 AM

  Hi
  Is it possible to drop and recreate SSISDB database.My collegue restored SSISDB to a new server and now all the packages are not running.I am thinking of dropping the DB ,recreate and then redeploy packages.

  Thanks

  T.

  As SSISDB is protected by a master key, you cannot simply move it to another server, you have to move (or recreate) the master key too.

  If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.

• tmmutsetse

  Hall of Fame

  Points: 3669

  More actions

  November 15, 2018 at 6:13 am

  #2013635

  Thank you,the guy didn't know about all that  and he just restored without encrytption keys.I went back to the old server and run the - backup master key to file = ' E:\temp|Testkey' encryption by password = ........

  I am getting an error ' cannot find the symmetric key 'master key',because it does not exist or you do not have permission.

  I am a sysadmin

• Phil Parkin

  SSC Guru

  Points: 246723

  More actions

  November 15, 2018 at 6:40 am

  #2013642

  tmmutsetse - Thursday, November 15, 2018 6:13 AM

  Thank you,the guy didn't know about all that  and he just restored without encrytption keys.I went back to the old server and run the - backup master key to file = ' E:\temp|Testkey' encryption by password = ........

  I am getting an error ' cannot find the symmetric key 'master key',because it does not exist or you do not have permission.

  I am a sysadmin

  Did you execute the query within the context of SSISDB?

  If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.