Re: subversion to back up SQL server

On Apr 27, 2006, at 9:48 AM, Ruslan Sivak wrote:
> I’m thinking of using subversion to back up sql server… Since SQL
> server full backups should differ little from backup to backup, I
> was hoping that subversion can store the full backups as deltas.
Even if you succeed in getting the per-revision disk usage down to a
reasonable level, you'll eventually find that your backups have
become huge. There's no easy way to get rid of old revisions in
Subversion. It's just not designed for this type of use.

> Should I be using some other utility instead?
rdiff-backup is designed to make reliable backups and keep deltas,
then eventually get rid of them. It's a better fit for what you want
to do, and I highly recommend it.

You likely will encounter this same problem, though - compression
makes deltas ineffective, so you'll want to find a way to turn off
whatever compression MS SQL Server is using.

-- 
Scott Lamb <http://www.slamb.org/>
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@subversion.tigris.org
For additional commands, e-mail: users-help@subversion.tigris.org