I’ve just released version 1.0 of MSSQL Compressed Backup. This is a command line utility that allows you to backup or restore your SQL Server 2005 databases to/from compressed files such as zip, bzip2, or gzip.
MSSQL Compressed Backup 1.0 Released
This entry was posted in MSSQL Compressed Backup and tagged MSSQL Compressed Backup, SQL Server Administration. Bookmark the permalink.
Hi Clay,
Very nice utility.
Is it somehow possible to state multiple databases to backup? each to a seperate file?
I know I can batch it, but will it take advantage of “virtual device”? meaning, creating it once and backing up all dbs from there?
I have too little knowledge how this “virtual device” works, so I am afraid that multiple repeated calls to msbp may not be efficent?
Thanks,
Peter
Pingback: Recent Links Tagged With "mssql" - JabberTags
Currently it isn’t possible to store multiple databases in the same virtual device. Interesting idea, though if the sole reason is for efficiency, I wouldn’t worry about it. It takes so little time to create a virtual device, like milliseconds.
The new version (1.1) prints when it starts to back up. You can use this to see how long the setup phase takes (including creating the virtual device) as compared to the backup phase.
Hi Clay,
Is it possible to backup a database in a named instance?
Thanks
David
David,
Definitely. The parameter is “instancename”. For example:
msbp.exe restore “local(path=c:\model.bak)” “db(database=model;instancename=sqlexpress;)”
You can read all the gory details here:
http://mssqlcompressed.sourceforge.net/doc_plugins_db.shtml