DB Mirroring

• doreamon333

  Old Hand

  Points: 362

  More actions

  July 4, 2011 at 12:45 am

  #240227

  Hi All,

  I'm new to DB mirroring the following is the step and something I've research and now have face some error

  Step 1:

  CREATE MASTER KEY ENCRYPTION BY PASSWORD = 'testing0123'

  Step 2:

  CREATE CERTIFICATE HOST_Main_cert

  WITH SUBJECT = 'HOST_Main certificate',START_DATE = '01/01/2010'

  After done 'Step 2' I've notice did not assign the expiry date information and the data view from

  select * from sys.certificates

  the Expiry Date is '01/01/2011'

  I've try to drop the certificate but error occur (the following is the step I have try)

  Drop Cert:

  Drop certificate HOST_Main_cert

  Msg 15559, Level 16, State 1, Line 2

  Cannot drop certificate 'HOST_Main_cert' because there is a user mapped to it.

  Can anyone advise me what command should I use? For me either remove the cert or update the cert expiry date.

  Thank You

  - David

• BLOB EATER

  SSChampion

  Points: 14609

  More actions

  July 5, 2011 at 7:46 am

  #1348281

  so you have objects that are encrpyted by that certificate that you are trying to drop?

• doreamon333

  Old Hand

  Points: 362

  More actions

  July 5, 2011 at 11:35 pm

  #1348740

  yup, I've figured out need remove the key before drop the cert. Thank you for the time