December 13, 2013 at 9:00 am
Hi, I am unable to do back up of certificate and private key. It giving the error message
BACKUP CERTIFICATE TDECertificate
TO FILE= 'C:\Program Files\Microsoft SQL Server\Key\TDECertificate.certbak’
WITH PRIVATE KEY
(FILE='C:\Program Files\Microsoft SQL Server\Key\TDECertificate.pkbak',
ENCRYPTION BY PASSWORD= 'Chinni1');
Msg 102, Level 15, State 1, Line 4
Incorrect syntax near '\'.
Msg 105, Level 15, State 1, Line 5
Unclosed quotation mark after the character string ');
December 13, 2013 at 10:24 am
When I grab this, the quote after the filename for the public side of the cert isn't a single quote, it's a literary quote.
December 13, 2013 at 11:14 am
I hope that's not the actual password you're using other places.
December 16, 2013 at 7:57 am
If I use TDE on a database in one instance and did the back up of certificate. But when I am creating certificate, I use only encryption key password only but there is no decryption. When I want to restore this database backup from this instance in another instance, how can I do?
December 16, 2013 at 7:57 am
If I use TDE on a database in one instance and did the back up of certificate. But when I am creating certificate, I use only encryption key password only but there is no decryption. When I want to restore this database backup from this instance in another instance, how can I do?
December 16, 2013 at 8:18 am
Create a master key in master, restore this certificate, then the restore of a TDE database is the same as any other database restore.
December 18, 2013 at 3:27 pm
Thanks for the reply. Please let me know how to restore that certificate that was created in another instance.
December 18, 2013 at 4:11 pm
You use the CREATE CERTIFICATE command with the FROM FILE option.
http://voiceofthedba.wordpress.com/2012/03/05/restoring-a-certificate/
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply