Security

Schedule Automatic Daily Database Backup Using Windows Task Scheduler

 Step-by-step guide to schedule automatic daily database backup (or any backup script) using Windows Task Scheduler.

Step 1. Create a Backup Script

Open Notepad.

Paste your backup commands. Example for Oracle RMAN backup:

rman target sys/password@XEPDB1 cmdfile='C:\backup\backup_script.rman' log='C:\backup\backup_log.txt'

Or a simple file copy script:

@echo off
xcopy "C:\MyData" "D:\Backup\MyData" /s /e /y /i

Save it as backup.bat

(Example Path: C:\backup\backup.bat and (file type : ALL))

 Step 2. Open Windows Task Scheduler

  1. Press Win + S, type Task Scheduler, and open it.
  2. In the Actions Panel, click Create Basic Task.

 Step 3. Configure Task Settings

  1. Name: Daily Database Backup
  2. Description: Automatically runs backup at 5:00 AM daily.
  3. Click Next.

 Step 4. Set Trigger

  1. Choose Daily.
  2. Click Next.
  3. Set Start Date and Time:
    (i) Start time: 05:00 AM
    (ii) Recurs every: 1 day
  4. Click Next.

 Step 5. Set Action

  1. Select Start a Program.
  2. Click Next.
  3. In Program/script, enter: C:\backup\backup.bat
  4. Click Next.

Step 6. Finish Setup

Review the summary and click Finish.

Optional (For More Control)

  • In Task Scheduler → Right-click your task → Properties:
    • Under General Tab:
      • Check Run whether user is logged in or not (if needed).
      • Check Run with highest privileges (if needed for admin tasks).
    • Under Settings Tab:
      • Ensure Allow task to be run on demand is enabled.
      • Enable Stop task if it runs longer than X (optional).

Conclusion

Your backup will now run automatically every day at 5:00 AM.

 
Membership not found