RE: subversion to back up SQL server

I'm presently not aware of any way of turning off compression of backups,
nor of an off-the-shelf DTS package that can backup an antire database to
text files. Though I'm sure one can fairly easily be written.

Instead of trying to diff a SQL backup, what happens if you detach the
database and commit that? Whilst the backup may differ each time, surely
the MDF itself won't change that much? I understand that this is only
feasible if you have a time window where you can take the database offline,
so it's not ideal to live use, but for development purposes it should be
acceptable.

Rupert.

PS. This is my first post the users group - have I done it properly?
PPS. What's a top-post?

-----Original Message-----
From: Kalin KOZHUHAROV [mailto:kalin@thinrope.net]
Sent: 28 April 2006 15:27
To: Ruslan Sivak
Cc: 'Andy Levy'; users@subversion.tigris.org
Subject: Re: subversion to back up SQL server

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
--
No virus found in this incoming message.
Checked by AVG Free Edition.
Version: 7.1.385 / Virus Database: 268.5.1/326 - Release Date: 27/04/2006
 
-- 
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.1.385 / Virus Database: 268.5.1/326 - Release Date: 27/04/2006
 
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@subversion.tigris.org
For additional commands, e-mail: users-help@subversion.tigris.org