正航進銷存軟體備份策略
先聲明這裡的步驟對資料庫及檔案有一定的風險,請務必有把握才使用,如果無法處理請直接聯絡原廠或經銷商處理,這裡只是僅為我協助公司備份筆記
使用MSSQL工具執行每小時遞增備份
每日執行刪檔bat (存成bat後再做排程) (為什麼要寫這個主因正航附帶的那支備份程式雖然每天都有幫我備份,但刪檔的功能無法在我這台主機實現,簡單用個bat每日執行就好)
forfiles /p E:\autobak /s /m *.* /d -7 /c "cmd /c del @path"
forfiles /p E:\CHI_INSTALL\chiautobackup /s /m *.* /d -7 /c "cmd /c del @path"
forfiles /p E:\MSSQL_BACKUP_EVERY1DAY\CHIComp01 /s /m *.* /d -7 /c "cmd /c del @path"
forfiles /p E:\MSSQL_BACKUP_EVERY1DAY\CHIComp02 /s /m *.* /d -7 /c "cmd /c del @path"
forfiles /p E:\MSSQL_BACKUP_EVERY1DAY\CHIComp07 /s /m *.* /d -7 /c "cmd /c del @path"
forfiles /p E:\MSSQL_BACKUP_EVERY1DAY\CHIComp98 /s /m *.* /d -7 /c "cmd /c del @path"
forfiles /p E:\MSSQL_BACKUP_EVERY1DAY\CHIComp99 /s /m *.* /d -7 /c "cmd /c del @path"
forfiles /p E:\MSSQL_BACKUP_EVERY1DAY\CHIXMSys /s /m *.* /d -7 /c "cmd /c del @path"
forfiles /p E:\MSSQL_BACKUP_EVERY1DAY\master /s /m *.* /d -7 /c "cmd /c del @path"
forfiles /p E:\MSSQL_BACKUP_EVERY1DAY\model /s /m *.* /d -7 /c "cmd /c del @path"
forfiles /p E:\MSSQL_BACKUP_EVERY1DAY\msdb /s /m *.* /d -7 /c "cmd /c del @path"
forfiles /p E:\MSSQL_BACKUP_EVERY1DAY\ReportServer /s /m *.* /d -7 /c "cmd /c del @path"
forfiles /p E:\MSSQL_BACKUP_EVERY1DAY\ReportServerTempDB /s /m *.* /d -7 /c "cmd /c del @path"
forfiles /p E:\MSSQL_BACKUP_EVERY1HOUR\CHIComp01 /s /m *.* /d -7 /c "cmd /c del @path"
forfiles /p E:\MSSQL_BACKUP_EVERY1HOUR\CHIComp02 /s /m *.* /d -7 /c "cmd /c del @path"
forfiles /p E:\MSSQL_BACKUP_EVERY1HOUR\CHIComp07 /s /m *.* /d -7 /c "cmd /c del @path"
forfiles /p E:\MSSQL_BACKUP_EVERY1HOUR\CHIComp98 /s /m *.* /d -7 /c "cmd /c del @path"
forfiles /p E:\MSSQL_BACKUP_EVERY1HOUR\CHIComp99 /s /m *.* /d -7 /c "cmd /c del @path"
forfiles /p E:\MSSQL_BACKUP_EVERY1HOUR\CHIXMSys /s /m *.* /d -7 /c "cmd /c del @path"
forfiles /p E:\MSSQL_BACKUP_EVERY1HOUR\model /s /m *.* /d -7 /c "cmd /c del @path"
forfiles /p E:\MSSQL_BACKUP_EVERY1HOUR\msdb /s /m *.* /d -7 /c "cmd /c del @path"
forfiles /p E:\MSSQL_BACKUP_EVERY1HOUR\ReportServer /s /m *.* /d -7 /c "cmd /c del @path"
forfiles /p E:\MSSQL_BACKUP_EVERY1HOUR\ReportServerTempDB /s /m *.* /d -7 /c "cmd /c del @path"
forfiles /p C:\Users\chi\Downloads /s /m *.* /d -7 /c "cmd /c del @path"
留言