Backup-Restore on Encrypted Columns

From: "Ike the Potato" <Ike@xxxxxxxxxxxx>
Date: Fri, 17 Feb 2006 12:10:58 -0700

I have some columns that are encrypted using SQL Server 2005 built in
encryption. What happens when I backup and restore this database on another
server? Does SQL Server have to re-encrypt these columns on this new
server? The Master Key is different on the new server, right?

--IKE

.

Prev by Date: Re: SQL Injection with ADO parameters
Next by Date: Re: SQL thinks it's Slammer
Previous by thread: Re: Permissions required to use Bulk Load with SQL Server 2005
Next by thread: Re: nt authority
Index(es):
- Date
- Thread

Relevant Pages

RE: WSS install locked into MSDE DB - Can not install for SQL Serv
... For the MASTER database ... Althought we change the Configuration Application pool several times ... interface BUT they appear to be MSDE databases and not SQL Server databases. ...
(microsoft.public.sharepoint.windowsservices)
Re: How to Replicate an SQL Server 2000 Database
... actual server name) enterprise manager should associate the database with the ... Looking for a SQL Server replication book? ...
(microsoft.public.sqlserver.replication)
Re: SQL 2005 Best Practice vs SQL 2000: Application Files Separate from data (and log) files
... I have had quite a number of clients that used a SAN for a database server and suffered significant performance problems because their underlying SAN infrastructure was a huge stripe across many drives. ... By application files I mean the binn folder which contains the sql server executable among other things. ...
(microsoft.public.sqlserver.setup)
Re: FCB::RemoveAlternateStreams: Operating system error (null)
... Thanks for all your help Ekrem, even if your sugestion does not solve the ... in this edition of SQL Server the ... database so it's opened again and you get this error somehow. ...
(microsoft.public.sqlserver.setup)
Re: Proposal for Lite Encryption for Login Form without SSL
... This way the password is not sent to the server ... simply copy the server-side salt used to hash the pw in the ... password in the database, it does make public the server-side salt ... This would be the equivalent to a public key in public key encryption ...
(comp.lang.php)