Python get backup of sql

>>> import pyodbc
>>> connection = pyodbc.connect(driver='{SQL Server Native Client 11.0}', 
                                server='InstanceName', database='master', 
                                trusted_connection='yes', autocommit=True)
>>> backup = "BACKUP DATABASE [AdventureWorks] TO DISK = N'AdventureWorks.bak'"
>>> cursor = connection.cursor().execute(backup)
>>> connection.close()

Source: stackoverflow.com

Similar codes

0 vote117 views1 answer
What is metadata in sql
SQL
7 votes116 views2 answers
What is sql clause
SQL
0 vote112 views1 answer
Min:sec datediff mssql
SQL
0 vote120 views1 answer
Mysql changer nom table
SQL
0 vote124 views1 answer
Postgresql auto increment not working
SQL
0 vote107 views2 answers
Add new column after in sql
SQL
0 vote138 views1 answer
Sqlalchemy query join many to many
SQL
0 vote107 views1 answer
Com.mysql.cj.exceptions.InvalidConnectionAttributeException more than one time zone. You must configure either the server or JD value if you want to utilize time zone support.
SQL
0 vote125 views1 answer
Get last date join sql
SQL
0 vote111 views1 answer
Sql clear table
SQL