Use Powershell to automate backup / restore of numerous databases?

technique · 2017-06-27

As per title we have a lot of Customer backups that we need to restore locally so that we always have a support environment setup for them. At the moment this is a manual task which is time consuming.

What we need are a couple of PS scripts that accept a parameter (ie. database name); one script to backup and another to restore dbs.

I've tried to search this info. out online and haven't been able to find anything but I'm sure other resellers are in the same predicament and someone must have solved it?

Any help would be fantastic, thanks in anticipation!!

vytjak · 2017-06-27

Have you looked at Waldo's / CRS powershell script library? -https://github.com/waldo1001/Cloud.Ready.Software.PowerShell

I think that's a great starting point and should be enough to begin with your backup/restore automation.

kennie · 2017-06-29

Can you use the official SQL Server Powershell commandlets:
Backup-SqlDatabase
Restore-SqlDatabase
?

See
https://docs.microsoft.com/en-us/powershell/sqlserver/sqlserver/vlatest/backup-sqldatabase

and

https://docs.microsoft.com/en-us/powershell/sqlserver/sqlserver/vlatest/restore-sqldatabase

Use Powershell to automate backup / restore of numerous databases?

Answers

Categories