Step 1
Generate Backup Script in Database Group
To generate backup script for all the databases under the selected database group
Right click the database group that you want to generate backup scrip
Generate Backup Script in Database ItemTo generate backup script for single databaseRight click the database that you want to generate backup script
Step 2Generate Backup Script
SMTP User: n/a. Leave emptySMTP Password: n/a. Leave empty Use SSL: False (or unticked)Email setting for Gmail SMTP Host: smtp.gmail.com SMTP Port No: 465 SMTP User: e.g.: <your-account>@gmail.comSMTP Password: ******* Use SSL: True (or ticked)Email setting for Yahoo! Mail SMTP Host: smtp.mail.yahoo.com SMTP Port No: 465 SMTP User: e.g.: <your-account>@yahoo.comSMTP Password: ******* Use SSL: True (or ticked)Email setting for private mail serverThe following a sample setting. Configure according to your private mail server setting. SMTP Host: <your-mail-server> SMTP Port No: 587 SMTP User: e.g.: <your-account>SMTP Password: ******* Use SSL: True or False
Step 3Add Backup task to Window 7 Task SchedulerClick window menu Start -> Accessories -> System Tools -> Task SchedulerClick Action -> Create Basic Task
3.Enter Task name
4.click next, choose when you want to trigger the task (e.g Daily)
5. Click next, choose the start date and start time and recur every 1 day
6. Click next, choose Start a Program
7. Click next, paste all the backup script text that you copied just now into “Program/Script”
Set the Start in(optional) path to the Exe folder (eg. C:EstreamSQL Accounting)Click next, a dialog prompted and click Yes
Click NextTick the option Open the Properties dialog for this task when I click Finish
Click FinishSelect the option Run whether user is logged on or not
Click Triggers tab at topClick Edit… button
Change the time to run
Click OK 2 times
Enter the window User Name & PasswordClick Ok
