USE master
CREATE MASTER KEY ENCRYPTION BY PASSWORD = '123456'
CREATE CERTIFICATE HOST_A_cert WITH SUBJECT = 'HOST_A certificate' ,
START_DATE = '01/01/2010'创建了一个证书后,如何删除掉?
CREATE MASTER KEY ENCRYPTION BY PASSWORD = '123456'
CREATE CERTIFICATE HOST_A_cert WITH SUBJECT = 'HOST_A certificate' ,
START_DATE = '01/01/2010'创建了一个证书后,如何删除掉?
drop certificate [VM2003_cert]
goif exists(select 1 from sys.databases where is_master_key_encrypted_by_server=1)
drop master key
go
go
drop master key
go
drop endpoint 端点名
go
--2、在主体服务器上,创建数据库主密钥
USE master
goif exists(select 1 from sys.endpoints where name=N'Endpoint_Mirroring')
drop endpoint Endpoint_Mirroring
go
--select * from sys.endpointsif exists(select 1 from sys.certificates where name=N'VM2003_cert ')
drop certificate [VM2003_cert]
go
--select * from sys.certificatesif exists(select 1 from sys.databases where is_master_key_encrypted_by_server=1)
drop master key
go
--select name, is_master_key_encrypted_by_server from sys.databases CREATE MASTER KEY ENCRYPTION BY PASSWORD = 'Mirror';
go
--select * from sys.symmetric_keys
--select name, is_master_key_encrypted_by_server from sys.databases