March 15, 2017 at 10:58 am
Hi
I am using Ola Hallengren's backup solution which has the ability to encrypt backups. If I am backing up all user databases with one job would that require all databases to have the same certificate?
Example:
EXECUTE dbo.DatabaseBackup @databases = 'USER_DATABASES',
@URL = 'https://myaccount.blob.core.windows.net/mycontainer',
@Credential = 'MyCredential',
@BackupType = 'FULL',
@Compress = 'Y',
@Encrypt = 'Y',
@EncryptionAlgorithm = 'AES_256',
@ServerCertificate = 'MyCertificate',
@verify = 'Y'
March 16, 2017 at 5:54 am
if you're specifying all user databases then they would use the same certificate
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 16, 2017 at 7:15 am
That is what i was thinking but wasn't sure. Thanks Perry I will give that a shot and let you know.
March 16, 2017 at 11:22 am
if you only wanted certain databases to use one certificate, for example all user databases except the databases FRED, BOB, JOE, then you could use
EXECUTE dbo.DatabaseBackup @databases = 'USER_DATABASES, -FRED, -BOB, -JOE'
,@URL = 'https://myaccount.blob.core.windows.net/mycontainer'
,@Credential = 'MyCredential'
,@BackupType = 'FULL'
,@Compress = 'Y'
,@Encrypt = 'Y'
,@EncryptionAlgorithm = 'AES_256'
,@ServerCertificate = 'MyCertificate'
,@verify = 'Y'
All the information you need is on Ola's website
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply