September 4, 2012 at 9:16 am
I'd like to restore a backup of a TDE-protected database to a different SQL 2008 R2 server instance. The target instance has no TDE DBs currently, but does have other databases running on it. (This is NOT a crises - This is for my own practice & education.)
I have backed up key & certificate files from the server where the backup was made. What exactly are the steps for restoring. Are the implications/risks for the other databases on the target server?
September 4, 2012 at 1:51 pm
dan-572483 (9/4/2012)
I'd like to restore a backup of a TDE-protected database to a different SQL 2008 R2 server instance. The target instance has no TDE DBs currently, but does have other databases running on it. (This is NOT a crises - This is for my own practice & education.)
dan-572483 (9/4/2012)
I have backed up key & certificate files from the server where the backup was made.
You don't need to backup the database master key or the service master key, just the certificate and it's private key and of course the database backup 😉
dan-572483 (9/4/2012)
What exactly are the steps for restoring.
see link above
dan-572483 (9/4/2012)
Are the implications/risks for the other databases on the target server?
There may be ramifications due to the encrypted Tempdb this can have an impact for other non encrypted databases.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply