Ola Hallengren backup script not splitting files as expected

1 vote

1 answer

119 views

sql-server backup ola-hallengren-scripts

                          I'm using Ola Hallengren backup script, with the following configuration:

>EXECUTE [dbo].[DatabaseBackup]  
@Databases = 'USER_DATABASES',  
@Directory = NULL,  
@BackupType = 'FULL',  
@Verify = 'Y',  
@CleanupTime = 192, -- 2 backups, so w/in 8 days  
@CleanupMode = 'BEFORE_BACKUP',  
@CheckSum = 'Y',  
@LogToTable = 'Y',  
@MaxFileSize = 256000	--Split files larger than 250GB

But my backups got split into 42 files, each sized just under 47GB.  I wanted to split into <250GB files.  Is something wrong with my configuration?


                        

Asked by MAW74656 (394 rep)

May 12, 2025, 07:35 PM
Last activity: May 14, 2025, 07:26 PM

Ola Hallengren backup script not splitting files as expected

Related Questions