george sibbald (5/15/2014)
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.
Take this scenario
I have ServerA with 1 default instance and database called BOB, backups for BOB are protected by the server certificate BobsBackups
I have ServerB with 1 default instance and database called FRED, backups for FRED are protected by the server certificate FredsBackups
I have ServerC with 1 default instance which is a test server, i want to restore to this test server backups of BOB and FRED.
I need to backup the cert BobsBackups on ServerA and also the cert FredsBackups on ServerB. On ServerC i then create the certs from the backup files using the CREATE CERT ... FROM FILE ....
Is this the scenario you were thinking of?
george sibbald (5/15/2014)
p.s. might be a line comment missing from the restore TSQL shown?
not sure what you mean by this
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉