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.
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.
Tags: MSSQL Compressed Backup, SQL Server Administration
This entry was posted on Sunday, August 24th, 2008 and is filed under MSSQL Compressed Backup. You can follow any responses to this entry through RSS 2.0. You can leave a response, or trackback from your own site.
Arclite theme by digitalnature | powered by WordPress
#1 by Peter at February 2nd, 2009
| Quote
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
#2 by Clay Lenhart at March 7th, 2009
| Quote
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.
#3 by David at November 2nd, 2009
| Quote
Hi Clay,
Is it possible to backup a database in a named instance?
Thanks
David
#4 by Clay Lenhart at November 3rd, 2009
| Quote
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