0

Currently I am using ola hallengren backup and maintenance scripts.

I have a question:

I have 5 big databases in one server. It's taking approximate 10+ hours everyday to complete full backups. Currently it's writing in sequentially into disk.

I want to write all backups parallel to reduce time. Is there any way I can write backups parallel?

I am taking compressed and verify only backups to network location

ven
  • 13
  • 1
  • 6

1 Answers1

5

Create additional jobs to run backups in parallel. Make sure to specify a single unique database per job. Configure the SQL Server Agent jobs to start the backup at approximately same time, with a 1 minute delay between each job.

You may find that running backup jobs simultaneously does not significantly decrease backup time. You should evaluate the I/O capability of the disks where the databases reside, the disks where the backups are being written to, and in the case of network backups, the capacity of the network to transfer data.

Hannah Vernon
  • 70,928
  • 22
  • 177
  • 323
Laurent
  • 73
  • 1
  • 8