W
W
Worlding2017-01-21 11:47:13
Backup
Worlding, 2017-01-21 11:47:13

How to automatically backup an open excel workbook and a local 1C database?

Tell me a program or a macro that can copy open excel files and an open local 1C database ?
I plan to copy to Yandex-disk .
Solution:
Excel .
Batch files copy open files without problems. So the standard windows scheduler + batch file solve this problem.

net use Y: https://webdav.yandex.ru пароль /user:яндекс-почта /persistent:no
copy "C:\Users\Admin\Documents\Folder\File.xlsx" "Y:\Backup\File.xlsx"

1C .
We register our variables in the " Worker-Peasant Backup under Windows " script, where, among other things, the folder for backups should be specified, for example, "C:\Users\Admin\Documents\Backup\1C". In this script, before the last line "Stop-Transcript" add:
net use Y: https://webdav.yandex.ru пароль /user:яндекс-почта /persistent:no
Copy-Item -Filter *.zip -Path C:\Users\Admin\Documents\Backup\1C -Recurse -Destination Y:\Backup -Force

+ Windows Scheduler. Thus, a shadow copy of the 1C base is made, and then it is copied to the Yandex disk.

Answer the question

In order to leave comments, you need to log in

1 answer(s)
A
Artem @Jump, 2017-01-21
@Worlding

Copying an open document, and even more so a database, makes sense only instantly.
It is used by the regular Windows backup service, so it is quite reasonable to use it.
Or such programs as akronis, and similar.
Yes, even sketch a script on the knee.

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question