February 5, 2015 at 9:05 am
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?
February 5, 2015 at 9:08 am
what exactly did you do to fix your master db corruption?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 5, 2015 at 9:10 am
Unfortunately it had to be rebuilt. It's a long story but there was no way to recover the master db.
February 5, 2015 at 9:12 am
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" 😉
February 5, 2015 at 9:13 am
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?
February 5, 2015 at 9:17 am
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" 😉
February 5, 2015 at 9:19 am
Backups were in place. Other issues caused the problem.
It's in the SSISDB catalog. I also can't export without the master key.
February 5, 2015 at 12:27 pm
presumably the original Visual Studio projects are stored securely somewhere
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 6, 2015 at 9:28 am
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