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 |
|
sqlpal2009
Yak Posting Veteran
58 Posts |
 Posted - 2009-03-10 : 10:30:55
|
| Hello All,How would I identify if my database is using any encrypted column? Will database restore populate the same data in encrypted column upon database failure or do I have to do anything special with these columns while taking the backups?Thanks in advance,-S |
|
|
guptam
Posting Yak Master
161 Posts |
Posted - 2009-03-11 : 00:40:23
|
| When your backup/restore database the data will be fine that is encrypted and stay encrypted. But you got to make sure to backup database master key also; you will need to do that in case you copy the database to another server or disaster recovery.Ref: http://technet.microsoft.com/en-us/library/aa337557(SQL.90).aspxThanks.-- Mohit K. GuptaB.Sc. CS, Minor JapaneseMCITP: Database AdministratorMCTS: SQL Server 2005http://sqllearnings.blogspot.com/ |
 |
|
|
|
|
|
Encrypted column