Knowledgebase

Search by Keyword

Search by Product

SE v2.1: Can't create scheduled backup using database utilities

(88 Views)
Operating System:

Windows 8, 8.1, and 10, and Server 2012

SE Version:

SE v2.1 Network Plus

Symptoms:

When you use the rnse_DBUtilities built-in scheduled backup feature, it does not save your selections. This is due to our program using the AT Command to create scheduled tasks, and this command has been deprecated in Task Scheduler 2.0 and appears to affect Windows 8 and 8.1, Windows 10, and Server 2012 at the time of writing this support article. Please see Microsoft's official documentation about this issue:

pointer What's New in Task Scheduler

Note: Even though it appears that the rnse_DBUtilities program does not save information, it actually does create the necessary files, but you will now have to manually create a scheduled task in Task Scheduler.

Solution:

After attempting to set the scheduled backup feature within the rnse_DBUtilities program, you should now have a folder named SupportFiles in your C:\Program Files (x86)\RNSENetworkPlus\RNSEServer folder (default path).

First open the folder and make sure you have the following three items:

  • mysqldump.exe
  • rnbackup.bat
  • rnScheduledBackup.exe

Then create a scheduled task in Task Scheduler:

  1. Go to Administrative Tools > Task Scheduler (or search for Task Scheduler)
  2. Click Action > Create Basic Task.
  3. When the wizard opens, name the task (ReadNatBackup) and set a description (Scheduled Backup Task for Read Naturally). Click Next.
  4. Select to set it to run Daily and click Next.
  5. Select the start date and time for when you want it to run. It runs very quickly (seconds). Set it to recur Daily (recur every 1 day). Our backups will overwrite files from the same day of the week from the prior week. So, at the most you will have seven files at any one time. Click Next.
  6. Select Start A Program (only functional choice), and click Next.
  7. Browse to the following item: C:\Program Files (x86)\RNSENetworkPlus\RNSEServer\SupportFiles\rnScheduledBackup.exe (default path). Click Next.
  8. Review the settings and click Finish.
  9. Find the new task (you may need to click Refresh on the right), right-click it, and select Run. Click Refresh on the right after a couple of seconds to make sure the status returns from Running to Ready.
  10. Go to the C:\Program Files (x86)\RNSENetworkPlus\RNSEServer\SupportFiles folder (default path), right-click rnbackup.bat, and select Edit. Set it to Word Wrap, and note the path where backup files are saved. Go to that path, and you should now see a backup file. These are often less than 1 MB in size, but need to be greater the 4 KB.
Notes:
  • If you do not see a file, view this suggested solution:
    pointer SE v2.1: Scheduled backup to a network location fails
  • You can edit the path where backup files are saved, either by editing the batch file or running the database utilities (rnse_DBUtilities) program and going through the motions of setting the schedule. Even though it appears to not save the settings, it does update the batch file.
Contact

Please let us know what questions you have so we can assist. For Technical Support, please call us or submit a software support request.

 
Click to refresh image