Friday, March 30, 2012

Moving an encrypted SQL Server DB to another server.

How can I move and encrypted database to another SQL Server 2005 box?
Can I just do an export of the database?
I read that I need to do this:
When an encrypted database is copied, restored, or attached to a new
instance of SQL Server, a copy of the database master key encrypted by the
service master key is not stored in master on the destination server
instance. On the destination server instance, you must open the master key of
the database. To open the master key, execute the following statement: OPEN
MASTER KEY DECRYPTION BY PASSWORD = 'password'. We recommend that you then
enable automatic decryption of the database master key by executing the
following statement: ALTER MASTER KEY ADD ENCRYPTION BY SERVICE MASTER KEY.
This ALTER MASTER KEY statement provisions the server instance with a copy of
the database master key that is encrypted with the service master key.
Is the above correct?
Thanks,
WarrenIn what way did you encrypt the database?
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Warren" <Warren@.discussions.microsoft.com> wrote in message
news:8857450C-395F-4CCA-9E8E-45D11ADC8C2D@.microsoft.com...
> How can I move and encrypted database to another SQL Server 2005 box?
> Can I just do an export of the database?
> I read that I need to do this:
> When an encrypted database is copied, restored, or attached to a new
> instance of SQL Server, a copy of the database master key encrypted by the
> service master key is not stored in master on the destination server
> instance. On the destination server instance, you must open the master key of
> the database. To open the master key, execute the following statement: OPEN
> MASTER KEY DECRYPTION BY PASSWORD = 'password'. We recommend that you then
> enable automatic decryption of the database master key by executing the
> following statement: ALTER MASTER KEY ADD ENCRYPTION BY SERVICE MASTER KEY.
> This ALTER MASTER KEY statement provisions the server instance with a copy of
> the database master key that is encrypted with the service master key.
> Is the above correct?
> Thanks,
> Warren
>

No comments:

Post a Comment