Detached DB After Dropping Certificate - Now I can't attached it

Question

Post reply

Detached DB After Dropping Certificate - Now I can't attached it

Viewing 10 posts - 16 through 24 (of 24 total)

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

arrjay Hall of Fame Points: 3455 More actions · Answer 1

arrjay

Hall of Fame

Points: 3455

January 23, 2014 at 6:19 am

#1682744

(removed)

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

Laughing in the face of contention...

arrjay Hall of Fame Points: 3455 More actions · Answer 2

Thanks for the link but it doesn't help me.

The situation I'm in is that I have removed the certificates from server A.

I have the certs on server B but I can't overwrite any of the data in the server A, I just want the certificates. Is there a way of copying over just the certificates.

Is it possible to remove all encryption from a databases that had the certificates so I can migrate them (remember, i don't have the certificate in this situation)

Thanks guys!!!

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

Laughing in the face of contention...

Perry Whittle SSC Guru Points: 233792 More actions · Answer 3

arrjay (1/23/2014)

Thanks for the link but it doesn't help me.

The situation I'm in is that I have removed the certificates from server A.

The link does help you, follow the section "To move a database". You need to do the following

backup the certificate on the server where the certificate exists (syntax shown in the link)
on the target server (if you haven't already), create a database master key in the master database (syntax shown)
create the certificate on the target server from the certificate backup file(syntax shown)
restore the protected database

arrjay (1/23/2014)

Is it possible to remove all encryption from a databases that had the certificates so I can migrate them (remember, i don't have the certificate in this situation)

Thanks guys!!!

Once you complete the above and get the database online you will then be able to disable the encryption supplied by the database encryption key

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

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

SQLRNNR SSC Guru Points: 281324 More actions · Answer 4

arrjay (1/23/2014)

the certs exist on another server (which the db orginally came from), is there a way of scripting them out and copying them to the server?

backup the certs from the source server and import them into the target server where you are trying to restore/attach this user database.

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

Greg Edwards-268690 SSC-Insane Points: 20667 More actions · Answer 5

Greg Edwards-268690

SSC-Insane

Points: 20667

January 23, 2014 at 7:51 am

#1682791

Thanks for helping Perry.

I probably should have made the link more obvious.

SQLRNNR SSC Guru Points: 281324 More actions · Answer 6

Greg Edwards-268690 (1/23/2014)

Thanks for helping Perry.

I probably should have made the link more obvious.

Nice job both y'all

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

Perry Whittle SSC Guru Points: 233792 More actions · Answer 7

the main point of confusion was that the OP was under the impression the cert was encrypted by password when in fact it wasnt, it's protected by the DMK. Had it been protected by a password and that password was lost then the database would have been useless

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

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