Options
Restores to encrypted database take much longer
meklembl
Posts: 107 Bronze 2
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).
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
Cleveland, OH USA
Comments
Database1 3,651,264
Database2 529,452,608
Database3 691,714,048
Database4 63,744
Database5 2,263,360
Cleveland, OH USA
It does seem to be working at acceptable levels for the time being.
Cleveland, OH USA