Groups > comp.databases.ms-sqlserver > #2247

Make a backup only if necessary

Path	csiph.com!news.mixmin.net!eternal-september.org!feeder3.eternal-september.org!news.eternal-september.org!.POSTED!not-for-mail
From	Anton Shepelev <anton.txt@g{oogle}mail.com>
Newsgroups	comp.databases.ms-sqlserver
Subject	Make a backup only if necessary
Date	Mon, 27 May 2024 12:59:29 +0300
Organization	A noiseless patient Spider
Lines	21
Message-ID	<20240527125929.d701039c2aec3196dc3d4731@g{oogle}mail.com> (permalink)
MIME-Version	1.0
Content-Type	text/plain; charset=US-ASCII
Content-Transfer-Encoding	7bit
Injection-Date	Mon, 27 May 2024 11:59:30 +0200 (CEST)
Injection-Info	dont-email.me; posting-host="a4a1e43aca0738c567b74d2649383417"; logging-data="4182492"; mail-complaints-to="abuse@eternal-september.org"; posting-account="U2FsdGVkX1+S1Y2ooTfod6s+5au5kgmurMbTiq4moCE="
Cancel-Lock	sha1:Jc5MDK1ODeWr2JfRTA02iShRe5k=
X-Newsreader	Sylpheed 3.7.0 (GTK+ 2.24.30; i686-pc-mingw32)
Xref	csiph.com comp.databases.ms-sqlserver:2247

Show key headers only | View raw

Hello, all

I am working on an in-house backup solution for our MSSQL
databases, and have found that a differential backup may
take considerable space (around 1 Mb) even if /no/ changes
have been made to the database since the previous full
backup. Is it possible somehow, before making another
differential backup, to check whether it makes sense, i.e.
whether the database has changed since the previous (full or
differential) backup? In fact, I do not need a criterium,
and a mere necessary condition will suffice.

I want to make sure that my differential backups are not
useless.  One solution is to compare byte-for-byte each new
diff. backup with the previous one, and delete the copy if
it turn out redundant, but I wondered if there were a
simpler method.

-- 
()  ascii ribbon campaign -- against html e-mail
/\  www.asciiribbon.org   -- against proprietary attachments

Back to comp.databases.ms-sqlserver | Previous | Next — Next in thread | Find similar

Thread

Make a backup only if necessary Anton Shepelev <anton.txt@g{oogle}mail.com> - 2024-05-27 12:59 +0300
  Re: Make a backup only if necessary Anton Shepelev <anton.txt@g{oogle}mail.com> - 2024-05-27 13:53 +0300
  Re: Make a backup only if necessary Erland Sommarskog <esquel@sommarskog.se> - 2024-05-27 22:43 +0200
    Re: Make a backup only if necessary Anton Shepelev <anton.txt@g{oogle}mail.com> - 2024-05-28 12:41 +0300
      Re: Make a backup only if necessary Erland Sommarskog <esquel@sommarskog.se> - 2024-05-28 20:11 +0200
        Re: Make a backup only if necessary Anton Shepelev <anton.txt@gmail.moc> - 2024-05-29 00:52 +0300
          Re: Make a backup only if necessary Anton Shepelev <anton.txt@g{oogle}mail.com> - 2024-05-31 13:53 +0300
            Re: Make a backup only if necessary Erland Sommarskog <esquel@sommarskog.se> - 2024-06-01 11:34 +0200
              Re: Make a backup only if necessary Anton Shepelev <anton.txt@gmail.moc> - 2024-06-02 14:43 +0300
                Re: Make a backup only if necessary Erland Sommarskog <esquel@sommarskog.se> - 2024-06-04 20:22 +0200
                Re: Make a backup only if necessary Anton Shepelev <anton.txt@g{oogle}mail.com> - 2024-06-05 17:15 +0300
                Re: Make a backup only if necessary Anton Shepelev <anton.txt@g{oogle}mail.com> - 2024-06-05 19:37 +0300

csiph-web