Post reply

Recreating SSISDB

  • 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.

  • 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

  • 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.

    The absence of evidence is not evidence of absence
    - Martin Rees
    The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
    - Phil Parkin

  • 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

  • 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?

    The absence of evidence is not evidence of absence
    - Martin Rees
    The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
    - Phil Parkin

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply