[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: Kalin KOZHUHAROV <kalin_at_thinrope.net>
Date: 2006-04-28 16:27:01 CEST

Please do *NOT* top-post.
[failed attempt to fix top posted content, deleting]

Ruslan Sivak wrote:
> The whole point is that I would like to keep a history of possibly
> older then 2 weeks, and not use a lot of space to do it.

Doesn't SQL Server have incremental backup? Something like a state of
the database at a certain point (snapshot?) + transaction log till
present.

> I understand that if you reorg or something, I might end up with a
> complete db backup again. But I did the backup a few mins apart...
> there shouldn't have been that many changes... Why did it backup the
> complete file again?
I bet this backup file is compressed with something. Depending on the
algorithm in use, a single bit change may have impact on a very large
block.

Try it with a text file (a.txt) and a compressed (a.txt.bz2) copy.
Copy a.txt to b.txt
Edit b.txt, changing a few characters
Compress b.txt into b.txt.bz2
Compare the changes between a.txt and b.txt
Do the same with a.txt.bz2 and b.txt.bz2

Can you turn compression off when backing up SS2005?
Any DTS service that can fully backup a SS2005 database in text files?

Hmm, any binary diff tool out there? Something like hexeditor but with
diff?
Or I need to write one that hexdumps the files and compare them
with normal diff?

Kalin.

-- 
|[ ~~~~~~~~~~~~~~~~~~~~~~ ]|
+-> http://ThinRope.net/ <-+
|[ ______________________ ]|
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@subversion.tigris.org
For additional commands, e-mail: users-help@subversion.tigris.org
Received on Fri Apr 28 16:28:34 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.