{"id":706,"date":"2018-01-26T17:42:41","date_gmt":"2018-01-26T09:42:41","guid":{"rendered":"http:\/\/www.irspossystem.com\/wiki\/2018\/01\/26\/auto-backup\/"},"modified":"2018-09-28T11:28:53","modified_gmt":"2018-09-28T03:28:53","slug":"auto-backup","status":"publish","type":"post","link":"https:\/\/www.irspossystem.com\/wiki\/2018\/01\/26\/auto-backup\/","title":{"rendered":"Auto Backup"},"content":{"rendered":"

Step 1<\/p>\n

Generate Backup Script in Database Group<\/p>\n

To generate backup script for all the databases under the selected database group<\/p>\n

Right click the database group that you want to generate backup scrip<\/p>\n

\"\"<\/p>\n

Generate Backup Script in Database ItemTo generate backup script for single databaseRight click the database that you want to generate backup script\"\"<\/p>\n

Step 2Generate Backup Script\"\"<\/p>\n

SMTP User: n\/a. Leave emptySMTP Password: n\/a. Leave empty\u00a0 \u00a0 \u00a0 Use SSL: False (or unticked)Email setting for Gmail\u00a0 \u00a0 SMTP Host: smtp.gmail.com\u00a0SMTP Port No: 465\u00a0 \u00a0 SMTP User: e.g.: <your-account>@gmail.comSMTP Password: *******\u00a0 \u00a0 \u00a0 Use SSL: True (or ticked)Email setting for Yahoo! Mail\u00a0 \u00a0 SMTP Host: smtp.mail.yahoo.com\u00a0SMTP Port No: 465\u00a0 \u00a0 SMTP User: e.g.: <your-account>@yahoo.comSMTP Password: *******\u00a0 \u00a0 \u00a0 Use SSL: True (or ticked)Email setting for private mail serverThe following a sample setting. Configure according to your private mail server setting.\u00a0 \u00a0 SMTP Host: <your-mail-server>\u00a0SMTP Port No: 587\u00a0 \u00a0 SMTP User: e.g.: <your-account>SMTP Password: *******\u00a0 \u00a0 \u00a0 Use SSL: True or False<\/p>\n

Step 3Add Backup task to Window 7 Task SchedulerClick window menu Start -> Accessories -> System Tools -> Task SchedulerClick Action -> Create Basic Task\"\"<\/p>\n

3.Enter Task name\"\"<\/p>\n

4.click next, choose when you want to trigger the task (e.g Daily)\"\"<\/p>\n

5. Click next, choose the start date and start time and recur every 1 day\"\"<\/p>\n

6. Click next, choose Start a Program\"\"<\/p>\n

7. Click next, paste all the backup script text that you copied just now into “Program\/Script”\"\"<\/p>\n

Set the Start in(optional) path to the Exe folder (eg. C:EstreamSQL Accounting)Click next, a dialog prompted and click Yes\"\"<\/p>\n

Click NextTick the option Open the Properties dialog for this task when I click Finish\"\"<\/p>\n

Click FinishSelect the option Run whether user is logged on or not\"\"<\/p>\n

Click Triggers tab at topClick Edit… button\"\"<\/p>\n

Change the time to run\"\"<\/p>\n

Click OK 2 times\"\"<\/p>\n

Enter the window User Name & PasswordClick Ok<\/p>\n","protected":false},"excerpt":{"rendered":"

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 […] More<\/a><\/p>\n","protected":false},"author":7,"featured_media":705,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-706","post","type-post","status-publish","format-standard","has-post-thumbnail","category-home"],"_links":{"self":[{"href":"https:\/\/www.irspossystem.com\/wiki\/wp-json\/wp\/v2\/posts\/706","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.irspossystem.com\/wiki\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.irspossystem.com\/wiki\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.irspossystem.com\/wiki\/wp-json\/wp\/v2\/users\/7"}],"replies":[{"embeddable":true,"href":"https:\/\/www.irspossystem.com\/wiki\/wp-json\/wp\/v2\/comments?post=706"}],"version-history":[{"count":1,"href":"https:\/\/www.irspossystem.com\/wiki\/wp-json\/wp\/v2\/posts\/706\/revisions"}],"predecessor-version":[{"id":784,"href":"https:\/\/www.irspossystem.com\/wiki\/wp-json\/wp\/v2\/posts\/706\/revisions\/784"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.irspossystem.com\/wiki\/wp-json\/wp\/v2\/media\/705"}],"wp:attachment":[{"href":"https:\/\/www.irspossystem.com\/wiki\/wp-json\/wp\/v2\/media?parent=706"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.irspossystem.com\/wiki\/wp-json\/wp\/v2\/categories?post=706"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.irspossystem.com\/wiki\/wp-json\/wp\/v2\/tags?post=706"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}