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 |
|
WV2NMAZ
Starting Member
2 Posts |
 Posted - 2011-11-16 : 19:33:47
|
| I've mirrored databases for some time without any problems until now. We have begun encrypting databases with TDE. I can easily mirror unencrypted databases, and I have no problem migrating enrypted databases to new servers. Performing both tasks is proving to be an obstacle. The setup is a simple mirror, without a witness, and with high performance. Whenever I try to mirror the database I receive the following message: Database cannot be opened, it is in the middle of a restore error: 927. As I mentioned earlier, simple TDE encryption is no problem - I copied the service master key, master key, and database certificate and I can freely use the database. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
WV2NMAZ
Starting Member
2 Posts |
Posted - 2011-11-16 : 22:31:25
|
| Thanks for your reply, Tara! I was able to resolve my problem by using the TSQL code ALTER DATABASE ... SET PARTNER. I had been attempting to use the Management Studio GUI to initiate mirroring, without success. I'm not sure what the difference is, but using the TSQL code worked. |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
Problem mirroring TDE database
I only use T-SQL when setting up mirroring, but that's just me. We don't use TDE (yet).Tara Kizer