SQL Server backup. PowerShell vs 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.)