Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 Certificate and symmetric keys. password backups

Author  Topic 

corvalion
Starting Member

6 Posts

Posted - 2008-04-24 : 04:52:07
Ok this is a question I have about SQL 2005 Certificate and symmetric keys.

If i create a certificate with an encryption by password and a symmetric key encryptted by the certificate every thing is fine and works great. The question I have is if the user changes the password and then fogets it is there a way of etracting the data by recreating the keys/data from backup, if so how. If not any suggestions as what best to do .

thanks
Chris
   

- Advertisement -