Rupert Martin wrote:
> 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.
OK, I *had* to start reading about SS2005 and other M$ technologies a few
days ago, so I am a n00b here, this was just a random idea ;-)
> 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.
That is a cool idea, you can try it for sure. Even if the DB in question is
mission critical, make a copy (replication) and set that off-line while doing
backup.
> PS. This is my first post the users group - have I done it properly?
Well, for a first post it is good, I've seen times worse cases :-)
> PPS. What's a top-post?
See http://en.wikipedia.org/wiki/Toppost
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 Sat Apr 29 04:17:10 2006