I
I
ITF2022-04-11 05:51:20
1C-Enterprise
ITF, 2022-04-11 05:51:20

How to reduce the size of a differential backup?

There is a database, .mdf size - 23GB
In the server settings there is a checkbox "compress backups" A task is configured to upload
a backup via an SQL query:

BACKUP DATABASE @BaseName
   TO DISK = @BackUpFileName
   WITH  NOFORMAT, NOINIT,
   NAME = @BackUpBaseName,
   SKIP, REWIND, NOUNLOAD, COMPRESSION, STATS = 10


Those. a complete copy is made, and then a similar request every hour diff.
Before a full backup, the database (.mdf) and log (.ldf) files are shredded.
At the end of the day, it is archived. But ... For some reason it is 39GB.

I take this file, deploy it next to it, start uploading the backup with my hands - the file turns out to be 5GB.
It is clear that this is without difference, but it is not clear that difference would show such a difference.

Answer the question

In order to leave comments, you need to log in

1 answer(s)
K
Konstantin Tsvetkov, 2022-04-11
@ITF

Optimize your 1C database, first using the configurator, and then using MS SQL. Compress the database file by file, optimally configuring each of them. For more information, enrich the Internet (there are many such guides).
62542cf30b4c2866045160.jpeg
Do a full backup at 6:00 and the differentials will be reduced many, many times over.

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question