Re: Help needed !

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: "Noor" <naissani@xxxxxxxxxxx>
Date: Mon, 8 Oct 2007 12:08:31 -0400

Alright, that means we don't need to re-create master key, Certificate and
symmetric Key?

Thanks Mohit

"Mohit K. Gupta" <mohitkgupta@xxxxxxx> wrote in message
news:A52CDDDC-1CCE-444F-8936-763CCFDF6C69@xxxxxxxxxxxxxxxx

Hi Noor,

You have to backup/restore the database master key and restore that
also.
THe master key is not backed up in the full database backup.

--
Mohit K. Gupta
B.Sc. CS, Minor Japanese
MCTS: SQL Server 2005

Prev by Date: RE: SQL Server 2000/2005 Client Tools and Connectivity
Next by Date: Restore remote db Locally.
Previous by thread: SQL Server 2008 - what means "Word based report authoring"
Next by thread: Restore remote db Locally.
Index(es):
- Date
- Thread

Relevant Pages

Re: Managing SQL Encryption -- Is there a Best Practice Doc?
... installed not when the Database Master Key is created. ... The Service Master Key is created when the instance of SQL Server is ... encryption to have the same Service Master Key? ...
(microsoft.public.sqlserver.security)
Re: Encrypted database deployment
... Did you back up all your Service Master Keys and Database Master Keys, ... you might see if you can successfully restore them ... it isn't the database master key so you now have two different master ... ALTER MASTER KEY ADD ENCRYPTION BY SERVICE MASTER KEY ...
(microsoft.public.sqlserver.security)
Re: Encrypted database deployment
... This issue is that the password is used to encrypt the database master key - ... ALTER MASTER KEY ADD ENCRYPTION BY SERVICE MASTER KEY ... environment, I get decryption errors, even though the Master Keys have ...
(microsoft.public.sqlserver.security)