Make a backup only if necessary

From	Anton Shepelev <anton.txt@g{oogle}mail.com>
Newsgroups	comp.databases.ms-sqlserver
Subject	Make a backup only if necessary
Date	2024-05-27 12:59 +0300
Organization	A noiseless patient Spider
Message-ID	<20240527125929.d701039c2aec3196dc3d4731@g{oogle}mail.com> (permalink)

Show all headers | 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