Name | Modified | Size | Downloads / Week |
---|---|---|---|
README.txt | 2011-05-20 | 2.4 kB | |
MSBPM-20110520.zip | 2011-05-20 | 106.9 kB | |
MSBPM-20110516.zip | 2011-05-16 | 106.4 kB | |
MSBPM-20091201.zip | 2009-12-01 | 106.5 kB | |
Totals: 4 Items | 322.3 kB | 0 |
MSSQL Backup Pipe Manager ************************* (c) 2011 Vinko Vrsalovic Installation ============ Unpack the files in a folder in the same machine you have MSBP installed. Configure using MSBPM.exe.config, the options are somewhat documented there. Run from a commandline the first time to see if it's doing what you wish it to. Schedule it in a scheduled task. Done! Release Date: 2011 05 20 (MSBPM-20110520.zip) Changes: Bug fixes for GZIP and BZIP2 support. Release Date: 2011 05 16 (MSBPM-20110516.zip) Changes: Added support for ONLINE dbs only. Release Date: 2009 12 01 (MSBPM-20091201.zip) First public release with plenty of bugs. Known bugs / limitations ======================== Online mode queries status once at the beginning, so if status changes in between the beginning and the actual MSBP execution, it will try to backup them anyway. It doesn't support trusted connections and requires a use with select permissions on sysdatabases. It doesn't support all the MSBP options. Configuration sucks for specific models only instead of a generic option. The running MSBP.exe instances are not killed when the MSBPM instance is killed, so, after killing (Ctrl-C or End Process) MSBPM.exe you have to manually look for and kill the remaining MSBP.exe processes (unless you killed MSBPM.exe in the right place between MSBP.exe executions.) It does it in a single threaded way, it should probably benefit from being able to run MSBP instances in parallel. Maybe via specifying in the configuration files how many instances you wish to run in parallel. It is not well tested, I have been using it for more than a year to backup our production databases, but not all the features and combinations of features have been tested. TODO ==== Improve configuration file to make it easier to use, adding support for all MSBP options. Support trusted connections. Add unit tests. Add a sixth option to select databases, via a SQL query. Fix online mode limitation. Add support for backup only written to databases after last backup (this requires to touch the retention code, as it is possible that backups are not made on each run.) Multithreaded MSBP runs. Kill the remaining MSBP.exe instances before dying. Thanks ====== To Clay Lenhart for MSBP and to Evert Meulie for bug reporting.