How can we help you today? How can we help you today?

Restores to encrypted database take much longer

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).
meklembl
0

Comments

2 comments

Sort by
  • meklembl
    DATABASE DATABASE_SIZE (KB)
    Database1 3,651,264
    Database2 529,452,608
    Database3 691,714,048
    Database4 63,744
    Database5 2,263,360
    meklembl
    0
  • meklembl
    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.
    meklembl
    0

Add comment

Please sign in to leave a comment.