Database Backup Considerations

today, a problem, the database backup, the data is not automatically compressed into RAR files, which is not conducive to saving server space, but also affect the circular backup.

previous ZIP files were installed in: C:\Program files (x86) \WinRAR, this directory affects database backups.
we can directly install the compressed file in the C packing directory: C:\WinRAR, execute the database script, it can be automatically compressed.
650) this.width=650; "id=" aimg_1235 "src=" http://bbs.delit.cn/data/attachment/forum/201603/17/ 003325gjfc6l7z86e081sm.png.thumb.jpg "width=" "height=" 196 "alt=" 003325gjfc6l7z86e081sm.png.thumb.jpg "/>

The following is the modified database backup script (the red font is the path of the RAR file):@ECHO OFF
D:\app\Administrator\product\11.1.0\db_1\BIN\exp system/[email protected] File=e:\oa data backup \db_bak\delit.dmp Owner=delit compress=y Log=e:\oa Data backup \db_bak\delit_exp.log
IF EXIST E:\OA data backup \db_bak\delit06. RAR DEL E:\OA Data backup \db_bak\delit06. RAR
IF EXIST E:\OA data backup \db_bak\delit05. RAR REN E:\OA Data backup \db_bak\delit05. RAR delit06. RAR
IF EXIST E:\OA data backup \db_bak\delit04. RAR REN E:\OA Data backup \db_bak\delit04. RAR delit05. RAR
IF EXIST E:\OA data backup \db_bak\delit03. RAR REN E:\OA Data backup \db_bak\delit03. RAR delit04. RAR
IF EXIST E:\OA data backup \db_bak\delit02. RAR REN E:\OA Data backup \db_bak\delit02. RAR delit03. RAR
IF EXIST E:\OA data backup \db_bak\delit01. RAR REN E:\OA Data backup \db_bak\delit01. RAR delit02. RAR
IF EXIST E:\OA data backup \db_bak\delit00. RAR REN E:\OA Data backup \db_bak\delit00. RAR delit01. RAR
C:\progra~1\winrar\rar. EXEa-df E:\OA Data backup \db_bak\delit00. RAR E:\OA Data Backup \db_bak\delit. DMP
@ECHO on


The following is the modified database backup script (the red font is the path to the RAR file):
@ECHO OFF
D:\app\Administrator\product\11.1.0\db_1\BIN\exp system/[email protected] File=e:\oa data backup \db_bak\delit.dmp Owner=delit compress=y Log=e:\oa Data backup \db_bak\delit_exp.log
IF EXIST E:\OA data backup \db_bak\delit06. RAR DEL E:\OA Data backup \db_bak\delit06. RAR
IF EXIST E:\OA data backup \db_bak\delit05. RAR REN E:\OA Data backup \db_bak\delit05. RAR delit06. RAR
IF EXIST E:\OA data backup \db_bak\delit04. RAR REN E:\OA Data backup \db_bak\delit04. RAR delit05. RAR
IF EXIST E:\OA data backup \db_bak\delit03. RAR REN E:\OA Data backup \db_bak\delit03. RAR delit04. RAR
IF EXIST E:\OA data backup \db_bak\delit02. RAR REN E:\OA Data backup \db_bak\delit02. RAR delit03. RAR
IF EXIST E:\OA data backup \db_bak\delit01. RAR REN E:\OA Data backup \db_bak\delit01. RAR delit02. RAR
IF EXIST E:\OA data backup \db_bak\delit00. RAR REN E:\OA Data backup \db_bak\delit00. RAR delit01. RAR
C:\WinRAR\RAR. EXEa-df E:\OA Data backup \db_bak\delit00. RAR E:\OA Data Backup \db_bak\delit. DMP
@ECHO on

Original address: http://bbs.delit.cn/thread-795-1-1.html

Reprint please specify the source:

Author: metric Technology http://www.delit.cn

Database Backup Considerations