Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
dmaxj
Posting Yak Master
174 Posts |
 Posted - 2011-02-16 : 14:39:02
|
| I have deployed Transparent Data Encryption (TDE) on 4 db's that are all on the same server in the same instance. I backed up the service master key 4 times for each db with 4 different passwords.I now realize that there is only one SMK. Will I be able to restore those 4 db's to a new sql server instance, even though the 4 smk file all have different passwords?Regards |
|
|
dmaxj
Posting Yak Master
174 Posts |
Posted - 2011-02-23 : 10:40:05
|
| So, I guess that I am outta luck? |
 |
|
|
|
|
|
Multiple service master keys