[sqlalchemy] Re: Can't get sqlalchemy to backup or restore MSSQL database

2011-07-12 Thread Maciej Filip Szkodziński
The database is part of a desktop accounting application running on Windows. I'm writing a program to interface with it, to automate adding documents. The idea was that it would be run once a month to add a bunch of invoices. The backup would run before this operation, in case something

[sqlalchemy] Re: Can't get sqlalchemy to backup or restore MSSQL database

2011-07-12 Thread Maciej Filip Szkodziński
and RESTOREs over ODBC trigger some kind of asynchronous / multiple result set mode. I'm guessing sqlalchemy closes the cursor before the server can finish the backup? On Jul 12, 4:25 pm, Michael Bayer mike...@zzzcomputing.com wrote: On Jul 12, 2011, at 8:27 AM, Maciej Filip Szkodziński

[sqlalchemy] Can't get sqlalchemy to backup or restore MSSQL database

2011-07-11 Thread Maciej Filip Szkodziński
Hello, I'm trying to backup a database running on SQL Server 2008 Express. I'm using pyodbc as the driver. This backup code executes happily, however no file is written to the provided path. I've also tried placing an empty file in the path, and only 2KB of data gets written to it. eng =