Reg : Backup job Scheduler...

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Title: Re: Backup Scheduler...
Dear All,
 
I did the Backup job schedule in windows through Schedule Task, it is working fine..
 
The following are the steps..
 
1. I created one batch file in my D:\Backup\postgres_backup.bat
      The contents are..
          
@echo off
rem "c:\Program Files\pgAdmin III\1.7\pg_dump.exe" -i -h localhost -p 5432 -U rajbackup -F t -b -f "postgres_db.tar" raj

rem "C:\Program Files\PostgreSQL\8.2\bin\pg_dump" -U (user name) -F c -f "postgres_db.bak" -F p -C -D (database name)
"C:\Program Files\PostgreSQL\8.2\bin\pg_dump.exe" -i -h localhost -p 5432 -U postgress -F c -v -f "D:\BACKUP\postgres_db.backup" Database name
rem "C:\Program Files\PostgreSQL\8.2\bin\pg_dump.exe" -i -h localhost -p 5432 -U postgress -F p -v -f "D:\BACKUP\raj\postgres_db.sql" Database name

@echno on
 
2. After i created one more  batchfile backup_post.bat
     The contents are
 
@echo off
REM author :jaikumar@.gmail.com,
REM Dont hasitate to a suggestions
call postgres_backup.bat
Set CURRDATE=CURRDATE.TMP
Set CURRTIME=CURRTIME.TMP
DATE /T > %CURRDATE%
TIME /T > %CURRTIME%
Set PARSEARG="eol=; tokens=1,2,3,4* delims=/, "
For /F %PARSEARG% %%i in (%CURRDATE%) Do SET YYYYMMDD=%%l%%k%%j
Set PARSEARG="eol=; tokens=1,2,3* delims=:, "
For /F %PARSEARG% %%i in (%CURRTIME%) Do Set HHMM=%%i%%j%%k

ren "D:\BACKUP\postgres_db.backup" "postgres_db_%YYYYMMDD%_%HHMM%.backup"

del currdate.tmp
del currtime.tmp
3. I scheduled the jobs in schedule task, that is in control pannel,
  a.  Task : -  Create new job name...
                   start in : D:\BACKUP\
                  RUN as : your login name
              put a tick mark in Enabled [scheduled task runs at specified time]
 
 b. Schedule..
     schedule task: Daily     start time : 12.00 am .... and go to Advance
        tick    Repeat task   ... Every column give (Hours u want) (mintues and hours)
        Duration   24...... give OK 
 
C. Settings  :     tick    Wake the computer to run this task..
 
d. Security  : check the login permissions..   and clik ok ... check the backup job stored place..
 
Thanks & Regards
Jayakumar M
 
 
 
 

DISCLAIMER:
This email (including any attachments) is intended for the sole use of the intended recipient/s and may contain material that is CONFIDENTIAL AND PRIVATE COMPANY INFORMATION. Any review or reliance by others or copying or distribution or forwarding of any or all of the contents in this message is STRICTLY PROHIBITED. If you are not the intended recipient, please contact the sender by email and delete all copies; your cooperation in this regard is appreciated..


[Index of Archives]     [KVM ARM]     [KVM ia64]     [KVM ppc]     [Virtualization Tools]     [Spice Development]     [Libvirt]     [Libvirt Users]     [Linux USB Devel]     [Linux Audio Users]     [Yosemite Questions]     [Linux Kernel]     [Linux SCSI]     [XFree86]

  Powered by Linux