Best way to move an encrypted MS SQL2005 database

Dear experts,

Please can you suggest the best way to move an encrypted database / table - MS SQL 2005 from one server to another?

We have moved it once but the user with the cert doesn't seem to be able to login to the db and i think we might be having the same problem as in this thread...

http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_21962666.html

Many thanks....
pjordannaAsked:
Who is Participating?
 
VeerabhadraiahhvConnect With a Mentor Commented:
hi

try this

--on primary server: backup service master key
backup service master key to file = 'service.key' encryption by password = 'MyPwd';
--on secondary server: restore service master key
restore service master key from file = 'service.key' decryption by password = 'MyPwd';

for more info:
http://www.sqlservercentral.com/articles/SQL+Server+2005+-+Security/3058/
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.