[svn.haxx.se] · SVN Dev · SVN Users · SVN Org · TSVN Dev · TSVN Users · Subclipse Dev · Subclipse Users · this month's index

RE: subversion to back up SQL server

From: Ruslan Sivak <rsivak_at_istandfor.com>
Date: 2006-04-27 19:06:22 CEST

I might research the sql server built in facilities a little more, but the
reason I want to use subversion is so that I can have an on-disk backup with
history. I would like to be able to pull up a backup from 2 weeks ago, and
not have to wait for tape to arrive...

With proper diffing, subversion should only be storing the changes in the
file, as opposed to the whole file, so in the end, the repository should
remain small.

Russ
-----Original Message-----
From: Andy Levy [mailto:andy.levy@gmail.com]
Sent: Thursday, April 27, 2006 1:02 PM
To: Ruslan Sivak
Cc: users@subversion.tigris.org
Subject: Re: subversion to back up SQL server

On 4/27/06, Ruslan Sivak <rsivak@istandfor.com> 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.
>
> In practice, however, this doesn't seem to be happening. I just did 2
full
> backups about 10 mins apart. The resulting backup file was 1.5gb. I
> checked in the first file, and 10 mins later overwrote it and checked in
the
> second file. The revs are approximately 1.2gb each. That's 1.2gb for the
> first import and 1.2gb for the change.
>
> Does subversion not work well with files larger then a certain limit?
> Should I be using some other utility instead?

SVN does do binary diffing. Not knowing the internal format of SQL
Server files, they may not lend themselves well to doing this or
compression, however.

This really doesn't sound like an appropriate use of SVN in the first
place, though. Unless your backup strategy needs to be able to see
what changed from snapshot to snapshot, you'd be much better off using
the SQL Server built-in backup facilities in conjunction with a
"regular" backup package writing to tape.

---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@subversion.tigris.org
For additional commands, e-mail: users-help@subversion.tigris.org
Received on Thu Apr 27 19:12:14 2006

This is an archived mail posted to the Subversion Users mailing list.

This site is subject to the Apache Privacy Policy and the Apache Public Forum Archive Policy.