parallel processing

Backup SQL Server Databases in Parallel with PowerShell

  • Article

I have a need to decrease the time my SQL Server database backups are taking to run. I thought about trying to run multiple backups at the same time to see if that would work. I could have created multiple SQL Server Agent Jobs to run at the same time, but I wanted a more dynamic way to handle this, so I created a PowerShell script that allows processes to run in parallel.

2017-10-30

3,911 reads

Blogs

Weekly reading #22

By

A little bit late but it is here! It is Wednesday already and we...

A simple powershell script to look up server hardware and OS information

By

This is a simple powershell script to query and display hardware and OS information...

Collecting Server Performance Metrics: Performance Monitor

By

Whether you’re a DBA/administrator looking to tune a server, planning for hardware updates, or...

Read the latest Blogs

Forums

Upgrading tables without downtime

By mikael_ljunghorn

Hi, We are in the process of a larger upgrade of an existing database....

-ExcludeJob with list dbatools

By abdalah.mehdoini

Hello everyone , I would like to transfer job sql lists through dbatools through...

Bulk Export of History Reports

By les.61

We are shutting down a SQL Server and would like to know if there...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers