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
Best Answer
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.