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 vote213 views1 answer
Oracle step procedure
SQL
0 vote199 views1 answer
Automate mysql cli query
SQL
0 vote204 views1 answer
Mysql cdn link
SQL
1 vote224 views1 answer
Ubuntu access database from terminal
SQL
1 vote224 views3 answers
Get all tables postgres
SQL
0 vote225 views1 answer
Change magento database url usimg musql
SQL
7 votes217 views6 answers
Reset identity column in sql server
SQL
5 votes196 views3 answers
How to remove unique key constraint in mysql
SQL
0 vote220 views1 answer
SQL Server Enterprise
SQL
11 votes218 views4 answers
Round in sql
SQL