How can I duplicate a SQL Server symmetric key?
Posted
by rlb.usa
on Stack Overflow
See other posts from Stack Overflow
or by rlb.usa
Published on 2010-04-02T20:07:40Z
Indexed on
2010/04/02
22:23 UTC
Read the original article
Hit count: 312
We have a server with a database that has a symmetric key (Database -> Security -> Symmetric Key). We have a backup duplicate databases that we are using as a test databases, but we don't have this key in there.
How can I duplicate this symmetric key (or make a new one exactly like the old) and put it in the existing databases? It has to have the same value and key-name as the other one.
This is on SQL Server 2008.
© Stack Overflow or respective owner