Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Need for Service Master Key backups, Database Master Key backups Expand / Collapse
Author
Message
Posted Thursday, August 22, 2013 2:41 AM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Tuesday, April 15, 2014 10:49 PM
Points: 488, Visits: 1,286
For enabling and moving TDE enabled databases certificate backup & private key are sufficient. Exactly under what scenarios you will need SMK backups , DMK backups or restore SMK , DMK backups

Regards,
Raj

Strictlysql.blogspot.com
Post #1487115
Posted Thursday, August 22, 2013 4:11 AM


SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Yesterday @ 11:21 AM
Points: 153, Visits: 946
arr.nagaraj (8/22/2013)
For enabling and moving TDE enabled databases certificate backup & private key are sufficient. Exactly under what scenarios you will need SMK backups , DMK backups or restore SMK , DMK backups


Usually you do not need either for especially TDE.

You should however always have a Backup of your Service Master Key ready for rare/unlikely corruption scenarios.
Same goes for the Database Master Key of master DB which protects your certificate.

In other cases when not using TDE but other encryption/signing techniques you may need a specific backup of the DMK for a restore of a user database.
So just protect yourself for the case. But make sure, the backup location itself is secure.


Andreas

---------------------------------------------------
MVP SQL Server
Microsoft Certified Master SQL Server 2008
Microsoft Certified Solutions Master Data Platform, SQL Server 2012
www.insidesql.org/blogs/andreaswolter
www.andreas-wolter.com
Post #1487153
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse