• Perry Whittle (10/22/2012)


    You just need to ensure that you have backups of all certificates (public and private keys) and backups of all the databases too. It might also pay to review the release notes for the service pack to get an idea of whats included.

    I just want to reiterate what Perry said. Make sure you have backups of those keys and databases. Worst case scenario without those backups is losing all data in the encrypted database.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events