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 |
|
poser
Posting Yak Master
124 Posts |
 Posted - 2012-03-09 : 13:18:09
|
| I have inherited a SQL Server that is at the end of its lifecycle..One of the databases is encrypted...and the backups will not restore on the new server. No one knows where the key is nor what the password would be. Is there any way to copy this database to the new server?Thanks for any help you can give...r/p |
|
|
dinakar
Master Smack Fu Yak Hacker
2507 Posts |
Posted - 2012-03-12 : 17:40:40
|
| without the encryption keys there's hardly any option..Dinakar Nethi************************Life is short. Enjoy it.************************http://weblogs.sqlteam.com/dinakar/ |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2012-03-12 : 18:20:47
|
| TDE? If so, you need to back up the certificates from the master database and restore those on the new server, look in books Online for the details of exactly what needs doing.Can't recall if you need any passwords for that or if sysadmin rights is enough.--Gail ShawSQL Server MVP |
|
|
|
|
|
|
Database Encryption