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 vote373 views1 answer
Sqlite unique multiple columns
SQL
18 votes330 views2 answers
Find all tables containing column with specified name - MS SQL Server
SQL
0 vote332 views2 answers
Postgresql get last day of month
SQL
-1 vote323 views2 answers
An error occurred while installing mysql2 (0.3.20), and Bundler cannot continue.
SQL
0 vote337 views1 answer
Dump multiple tables mysql
SQL
6 votes777 views3 answers
Sql select last id
SQL
21 votes349 views4 answers
Add column mssql
SQL
1 vote346 views1 answer
Oracle grant select on schema
SQL
0 vote327 views2 answers
Mysql add days to date
SQL
11 votes361 views4 answers
MYSQL LOGIN
SQL