On Apr 27, 2006, at 18:48, 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.
>
> 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?
I don't know "SQL server". I use MySQL. I know that its database
files are binary, but that you can create a text dump of the
databases' contents. Are you trying to check text dumps into
Subversion or the original binaries? I would expect the latter not to
work very well in terms of disk space usage, and the former to work
very well. To make it easiest on you to see differences and be able
to restore them, I'd recommend dumping each database to a separate
file, or even each table.
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@subversion.tigris.org
For additional commands, e-mail: users-help@subversion.tigris.org
Received on Thu Apr 27 21:23:52 2006