SQL Server Backup and Restore with Powershell

Powershell SQL Server Module

Alim Dogan
Feb 6, 2021

Check if your module installed on your system

List all databases

Backup-SQL database

Backup all databases for example

Get-ChildItem “SQLSERVER:\SQL\$SQLInstance\Databases” | Backup-SqlDatabase -BackupContainer G:\Foldername -CopyOnly

And be specific

--

--

Alim Dogan

I am a SQL Server Database Administrator, and I thoroughly enjoy my work. https://github.com/alimdogan