Visit the following link (SQL.90).aspxfor information on how to create identical symmetric keys on two serversīoth servers should have the same Service Master Key In all options, the domain should be changed as the Operating System level uses the Service Account or SPN to encrypt the Service Master KeyĪs long as the SQL instance is still functional, the Service Master Key and Database Master Key will still be functional. Recreate the Certificate and Symmetric Keys and the data will be accessible. The encryption is applied in a top down manner, so the Operating System level secures the Service Master Key (SMK), etc.Īs discussed in Database Disaster Recovery Options, there are four SQL Disaster Recovery Options which are supported by K2.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |