Issue with using Ola Hallengren Backup script

Question

Issue with using Ola Hallengren Backup script

Viewing 6 posts - 16 through 20 (of 20 total)

You must be logged in to reply to this topic. Login to reply

Jeff Moden SSC Guru Points: 1003857 More actions · Answer 1

Ola Hallengren - Tuesday, April 3, 2018 7:38 AM
I have released a new version of the script with support for striping of backups to Azure Blob Storage, MAXTRANSFERSIZE, and BLOCKSIZE.
https://ola.hallengren.com/versions.html
Could you please download the latest version and test again.
https://ola.hallengren.com/downloads.html
Ola Hallengren
https://ola.hallengren.com

It's things like this that give people, like Paul Randal, good reason to call your code "The Gold Standard" in many areas of maintenance. Hat's off to you, Ola.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

Revane Newbie Points: 3 More actions · Answer 2

I want to differ @numberoffiles parameter value for different databases, for example I want to use 2 backup file for testA database, 1 backup file for testB database. Because some databases in production has already size more than 1 Tb and 1 blob is not enough. How can I solve this problem in OH's backup script for only full backups.

Jeff Moden SSC Guru Points: 1003857 More actions · Answer 3

Ummm... call Ola's stuff differently for specific databases?

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

Revane Newbie Points: 3 More actions · Answer 4

No, I created full backup job with OH's backup script for all user databases like the following parameters:

EXECUTE [dbo].[NewDatabaseBackup]

@databases = NULL,

@Directory = NULL,

@BackupType = 'FULL',

@verify = 'Y',

@Compress = 'Y',

@CopyOnly = 'N',

@ChangeBackupType = 'Y',

@checksum = 'Y',

@Description = @urlbckdesc,

@Encrypt = 'N',

@EncryptionAlgorithm = NULL,

@ServerCertificate = NULL,

@ServerAsymmetricKey = NULL,

@EncryptionKey = NULL,

@OverrideBackupPreference = 'N',

@NoRecovery = 'N',

@MirrorDirectory = NULL,

@AvailabilityGroups = @avgname,

@Updateability = 'ALL',

@LogToTable = 'Y',

@Execute = 'Y',

@URL = @urldir1,

@MirrorURL = @urldir2,

@MAXTRANSFERSIZE=4194304,

@BLOCKSIZE=65536,

@DatabasesInParallel = 'Y',

@DatabaseOrder=DATABASE_SIZE_ASC,

@jobname='MONTHLY_FULL_BACKUP_URL_PARALLEL'

EXECUTE [dbo].[NewDatabaseBackup]

@databases = 'USER_DATABASES,-AVAILABILITY_GROUP_DATABASES',

@Directory = NULL,

@BackupType = 'FULL',

@verify = 'Y',

@Compress = 'Y',

@CopyOnly = 'N',

@ChangeBackupType = 'Y',

@checksum = 'Y',

@Description = @urlbckdesc,

@Encrypt = 'N',

@EncryptionAlgorithm = NULL,

@ServerCertificate = NULL,

@ServerAsymmetricKey = NULL,

@EncryptionKey = NULL,

@OverrideBackupPreference = 'N',

@NoRecovery = 'N',

@MirrorDirectory = NULL,

@AvailabilityGroups = NULL,

@Updateability = 'ALL',

@LogToTable = 'Y',

@Execute = 'Y',

@URL = @urldir1,

@MirrorURL =@urldir2,

@MAXTRANSFERSIZE=4194304,

@BLOCKSIZE=65536,

@DatabasesInParallel = 'Y',

@DatabaseOrder=DATABASE_SIZE_ASC,

@jobname='MONTHLY_FULL_BACKUP_URL_PARALLEL'

But there are two AG database that has 1.2Tb,1.4Tb size and raise error -"Device has reached its limit of allowed blocks"- while backup, I want to backup of these databases with the same procedure in the same backup job. If I change @numberoffiles parameter value to 2 then 2 backup files are used for all databases, I can't differentiate database name within the procedure

Jeff Moden SSC Guru Points: 1003857 More actions · Answer 5

Disclaimer: I don't use Ola's good code nor do I use "AG" (we use something else at work).

I understand that you currently have a single job but it would appear that you need to have more than one with different settings... unless you modify Ola's code to do something according to database size (and I don't recommend that. Make separate calls instead.).

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

Revane Newbie Points: 3 More actions · Answer 6

Revane

Newbie

Points: 3

December 19, 2019 at 4:57 am

#3708962

I called procedure two twice in the job