November 28, 2019 at 1:07 pm
Hi
I'm migrating databases from server that does not have TDE enabled, to another server that will have it enabled.
Ideally I'd like to create the databases\schema on the new server, enable TDE on the databases and then restore data into them so SQL encrypts the data as it writes it to the database file. I'm pretty sure that if I just backup and restore the databases they won't be encrypted at the destination. Is there a way to do this, that is fairly straightforward. We have a limited maintenance window so I want a simple and quick way to end up with a TDE encrypted database on the new server. I have to restore then, encrypt SQL has effectively read\written every data page twice.
Is there a way?
Alex
November 29, 2019 at 1:05 am
You can only encrypt a database that exists and is fully recovered. Restore only re-paints the disk pages as it copied them from the source database.
Either encrypt the database before you move it, or after. You cannot do so during the restore.
Eddie Wuerch
MCM: SQL
November 29, 2019 at 8:08 am
That's what I thought Eddie.
Thanks for the reply
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply