April 5, 2018 at 6:35 am
Ola Hallengren - Tuesday, April 3, 2018 7:38 AMI 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.htmlCould you please download the latest version and test again.
https://ola.hallengren.com/downloads.htmlOla 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
Change is inevitable... Change for the better is not.
December 16, 2019 at 10:35 pm
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.
December 16, 2019 at 11:20 pm
Ummm... call Ola's stuff differently for specific databases?
--Jeff Moden
Change is inevitable... Change for the better is not.
December 17, 2019 at 7:33 am
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
December 17, 2019 at 3:35 pm
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
Change is inevitable... Change for the better is not.
December 19, 2019 at 4:57 am
I called procedure two twice in the job
Viewing 6 posts - 16 through 21 (of 21 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy