Restoring unencryped database into an encrypted database

  • 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

  • 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

  • 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