1

I am using Ola Hallengren backup solution in all our environment, I have a very big Backup file which is taking 10+ hours to complete, so I am thinking to split SQL Server Full backup files.

anyone know how to split backup files in ola hallengren backup solution or else tell me if I need to create different maintenance plan only for one BIG DB

Thanks, Ven

2

In addition to Scott's answer, there is also the NumberOfFiles parameter which would let you create multiple files under the same directory, if desired.

| improve this answer | |
1

According to the documentation for Ola's BACKUP solution, you can specify the DIRECTORY parameter with multiple directories. Quoting from the documentation:

If you specify multiple directories, then the backup files are striped evenly across the directories. Specify multiple directories by using the comma (,). If no directory is specified, then the SQL Server default backup directory is used.

| improve this answer | |

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.