Accidental creation of certificate and symmetric key on master database.

  • I meant to setup a certificate and symmetric key for a specific database on one of my servers. I accidentally created the key while pointing to the master database. Can I drop the key without consequence?

  • bkrankel (3/7/2014)


    I meant to setup a certificate and symmetric key for a specific database on one of my servers. I accidentally created the key while pointing to the master database. Can I drop the key without consequence?

    I believe the answer is YES, but please don't try this on a production server without testing first.

    Please set up a VM or another machine, install SQL and create the keys there, then drop the key and see what happens.

    Thanks

    John

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply