SSIS Issues after Master DB Corruption - "Please Recreate Master Key" When Running Package

  • Hello All,

    Had a giant issue with master db corruption last night that caused some massive problems. After spending hours fixing it, everything is running except for some dtsx packages. When I'm running a dtsx package, i'm getting an error stating "Description: Please create a master key in the database or open the master key in the session before performing this operation. Source: .Net SqlClient Data Provider Started: 8:00:01 AM Finished: 8:00:02 AM Elapsed: 1.016 seconds. The package execution failed. The step failed."

    I don't have a backup of the master key. So what are my steps?

  • what exactly did you do to fix your master db corruption?

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • Unfortunately it had to be rebuilt. It's a long story but there was no way to recover the master db.

  • JoshDBGuy (2/5/2015)


    Unfortunately it had to be rebuilt.

    Once you rebuilt the system databases you should have restored master from a backup, I'm guessing you didn't?

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • Perry Whittle (2/5/2015)


    JoshDBGuy (2/5/2015)


    Unfortunately it had to be rebuilt.

    Once you rebuilt the system databases you should have restored master from a backup, I'm guessing you didn't?

    Could not, inherited system, issue with master backup restore process. It was a nightmare.

    Luckily it's only two SSIS packages. Can I rebuild them?

  • JoshDBGuy (2/5/2015)


    Could not, inherited system, issue with master backup restore process. It was a nightmare.

    so when you inherit a system always check that critical backups are in place

    JoshDBGuy (2/5/2015)


    Luckily it's only two SSIS packages. Can I rebuild them?

    are they file system packages

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • Backups were in place. Other issues caused the problem.

    It's in the SSISDB catalog. I also can't export without the master key.

  • presumably the original Visual Studio projects are stored securely somewhere

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • Luckily we found a backup of the keys. Thanks for the assistance. I have a lot of adjustments to make on my end to mitigate this issue in the future.

Viewing 9 posts - 1 through 8 (of 8 total)

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