September 23, 2014 at 12:10 pm
Hi,
I need to restore the database backup from one server to another server. That database has TDE enabled.
We need to restore the masterkey for the database restore.
How to find is that master key is already existed or not on that other server.
If we need to restore one time, is that enough or do we need restore the master key each time
Thanks
September 23, 2014 at 12:19 pm
It's not the master key but the encrypting certificate that needs to be restored to the new server.
Here is an article that shows the steps needed.
http://msdn.microsoft.com/en-us/library/ff773063.aspx
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
September 23, 2014 at 12:23 pm
Hi,
How to check existence of symmetric key on the another server to restore the TDE deatabase backup
September 23, 2014 at 12:26 pm
You can check for the certificate to see if it has been restored by use of the catalog view.
select *
From sys.certificates
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
September 23, 2014 at 12:32 pm
Yes. Got it
Thank you
September 23, 2014 at 12:32 pm
You're welcome.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
September 24, 2014 at 5:04 am
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply