SQL Server backup. PowerShell vs Python I'm about to refactor inherited scripts deployed on multiple servers that backup many other servers. They are a mixture of cmd, vbs and sql. I'm pondering what benefits would bring doing it with Python since I find it friendlier to script?
Mainly i'm thinking that with PS I can use something that could be considered native like Invoke-Sqlcmd or sqlps. 
Is it just a matter of taste or might I stumble upon something nasty and unforeseen by using python?
I am not familiar with Python, but for your current requirement (i.e. backup).
I'd strongly recommend you to use PowerShell for two reasons:


MS in its SQLPS module (since SQL Server 2012), has a native cmdlet called

Backup-SQLDatabase
You may run this cmdlet on one central server to do the backup against multiple sql instances at once because this Backup-SQLDatabase can accept multiple sql instances, like the following example

Backup-SQLDatabase -Database master -Server "my_server1", "my_server2" ...


This 2nd point may help you to centralize all those backup scripts to one administration server (dedicated for DBA use) instead of sparsely stored on each sql server instance.


Also with MS providing Backup-SQLDatabase, you can be assured that it will be supported for all future new features. (For example, using this cmdlet to support Azure SQL Database etc.)