Post Office Database Backup Tool v1.0

ABOUT

Name: PO_BACKUP  V1.0

Designed and Published: A.ASHOKKUMAR

Objective: Daily backup of SQL databases in POs

Highlights

1. No need to configure your server name and login credentials.
2. Backed up all databases with single click.
3. Creates a folder as per your system date automatically.
4. Navigates you automatically to Databases directory, hence you can easily cut and copy *.bak files to date folder.

Setup Instructions

STEP-1:

1. Application installation path should be  “ D:\PO_BACKUP\ ”
2. Make sure that “D:\” is not a CD drive or Removable drive

STEP-2:

1. Configure your “backup.sql” query file. 
2. You can find it at “D:\PO_BACKUP\QUERY\backup.sql”
3. You can replace it with your existing sql backup query or prepare afresh. But name should be “backup.sql” and keep it in the folder “D:\PO_BACKUP\QUERY\backup.sql”
4. To prepare afresh click on “DATABASE NAMES” under “View” Menu. Then your database names contained text file will be opened. 
5. Suppose You have books, songs as databases in text file then you configure “backup.sql” as follows:

BACKUP DATABASE BOOKS TO DISK=’D:\PO_BACKUP\DATABASES\BOOKS.bak’
BACKUP DATABASE SONGS TO DISK=’D:\PO_BACKUP\DATABASES\SONGS.bak’

If you have 30 databases in your server then configure as same above for all databases.

STEP-3:

• Remember that in future if you create a database in your server then don’t forget to add backup query line in the “backup.sql” file as mentioned in above.

Download Backup Tool

Download

Thanks to A.ASHOKKUMAR,SPM,RAYAKUDURU-534247
e-Mail: “ spm.rayakuduru.so@gmail.com “