The script will allows you to enter an instance name from which it will connect to and backup all the databases present: workflow WF-ParallelSqlBackup While I can execute this script to backup all the databases one after the other, I could also use some techniques to backup all my databases at the same time.
There are quite a lot of examples so let’s pick one: Let’s see some examples of the cmdlet: Get-Help Backup-SqlDatabase -Examples Let’s explore the new PowerShell module for SQL Server and see if there is a backup cmdlet. Of course we need to take into account that starting backups for all the databases on an instance could be a possible problem due to performance on the disk or over the network.
One of the strong features of a workflow is to go parallel which could potentially reduce the time backup all the databases. I wanted to test something since my last presentation where I discussed using workflows in PowerShell. If you haven’t heard from it you can become a member of the of the virtual chapter for PowerShell and if you like instant messaging, become member of the Slack SQLServerCommunity. If not you don’t do much with PowerShell or you’re probably not a member of the PASS PowerShell VC. You probably heard about the new PowerShell module for SQL Server called “SqlServer”. I will show a scenario where an instance will backup all the databases at almost the same time.
WORKFLOWY BACKUP HOW TO
This post will show you how to backup databases using workflows in parallel.
0 kommentar(er)
