• dimadd2005 (9/1/2015)


    If you change your service account on the second machine to local System.

    and then restore your master keys it just work.:-)

    The point is you don't restore the SMK, it's generated based on the machine account and the user account running the sql server service. You do not need to restore the SMK in order to move a TDE protected database. You just need a backup\restore of the certificate used by the database in order to restore to another server

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉