What are the challenges you face when working across database platforms? Take the survey
Options

Restores to encrypted database take much longer

meklemblmeklembl Posts: 107 Bronze 2
edited October 19, 2015 2:28PM in SQL Backup Previous Versions
I am using SQL Server 2008 running on OS Server 2008
I have two servers that have five databases on each of them.
On ServerA, I have Database1, Database2, Database3, Database4, and Database5.
On ServerB, I have Database1, Database2, Database3, Database4, and Database5.
Every night, I backup Database1, Database2, Database3, Database4, and Database5 from ServerA and restore them to ServerB. The backup took about 2.5 hours. The restore sometimes took 4 hours.
The timing of them worked fine as I was using the data on ServerB for reporting.

Now I had to encrypt the data at rest on so I used TDE to do so on both servers. My backups do not seem to take any longer, but my restores take nearly two to three times as long (6-8 hours).
Larry M
Cleveland, OH USA

Comments

  • Options
    meklemblmeklembl Posts: 107 Bronze 2
    DATABASE DATABASE_SIZE (KB)
    Database1 3,651,264
    Database2 529,452,608
    Database3 691,714,048
    Database4 63,744
    Database5 2,263,360
    Larry M
    Cleveland, OH USA
  • Options
    meklemblmeklembl Posts: 107 Bronze 2
    It may be somewhat slower on both the backups and the restores, but not even close to what I originally saw.

    It does seem to be working at acceptable levels for the time being.
    Larry M
    Cleveland, OH USA
Sign In or Register to comment.