• Perry, thanks for the article.

    If you have a test server on which you may restore backups from multiple prod servers how is that handled? Do you need to copy down the certificate from each prod server to a different location on the test server, or do you go for using a password instead and using the same password across your environment.

    p.s. might be a line comment missing from the restore TSQL shown?

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