It is possible with SQL Server 2016 (possibly earlier as well) to use Powershell to backup your databases. If I ever need to do this I use the SQL Management console, however I’m using a Mac through RDP which means right click is not working 🙂
It’s very easy to take the backup, set the variables, of server name, db name and output path.
|$server = “TWSQL1”$database = “ConfigMgr”$output = “C:\Users\Administrator\Desktop\SQL\ConfigMgr.bat”|
Backup-SqlDatabase -ServerInstance $server -Database $database -BackupFile $output