Re: subversion to back up SQL server

On 4/27/06, Ruslan Sivak <rsivak@istandfor.com> wrote:
> 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...

You can do that with the built-in backup. Might need an extra script
to blast any backup older than 2 weeks, but that's not hard to write.

> 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.

Unless you do a reorg, make a table definition change, re-index the
table, shrink the database, etc.

---------------------------------------------------------------------
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:19:23 2006