Download https://dl.waspbarcode.com/kb/ma/v7/BackupDB4MA.zip and extract it on the database server machine.

Create a new folder on your server's drive, C:\MobileAssetBackups. Typically this new folder will be created with the correct permissions, but if your environment is very restrictive, you may need to edit the security properties to allow Everyone to have Full Control of the folder, or if that is not possible, to allow the user account in use by the SQL Server service to have full control.

If you would rather use a different folder, or if your SQL Server installation uses a different SA password, edit BackupDB4MA.wql with Notepad to change the line starting "SET @FileName" or the "password=" line. IF you are changing the file path, be aware that it must be directed to a folder that exists on the server's local hard drive, not a network drive, or the script will fail.

Run BackupDB4MA.bat to create the backup file, C:\MobileAssetBackups\MAbackup_<datestamp>.bak.

To schedule this process to run automatically, you can make use of the Windows Task Scheduler, as follows:

In Windows 7, go to Start > All Programs > Accessories > System Tools > Task Scheduler. It may spend a few seconds adding a snap-in to the management console, then it will open. On the Actions pane at the right, select Create Basic Task. Provide a name for the task, like WaspBackup, then click Next. Chose how often you wish the process to run from the list, then click Next to enter the details. Depending on how often you selected, you will be prompted to enter the day of the week or month and the time to run the process. On the next page, it will ask what action you want it to perform. Click the radio button for "Start a program" and click Next, then Browse. Locate BackupDB4MA.bat, select it and click Open, then Next. If you check the box for "Open the Properties dialog for this task when I click Finish", it will open an interface with many additional conditions for the task. This is where you can specify a different user for the task to run as, as well as options for whether to run when the user is logged in only, or whether the user is logged in or not. It does default to only when the user is logged in. Also, on the Settings tab, there are boxes for "Run task as soon as possible after a scheduled start is missed" and "If the task fails, restart every:", which you should look at. This Properties window is the same as what opens if you initially choose Create Task rather than Create Basic Task, so you may start here, but the initial rule creation may be easier in Basic Task. To see the task, click Task Scheduler Library at the top left. Click on the task in the top center pane, and the Properties will be shown in the bottom center pane for verification. If you need to change any of the settings, you will need to right click the task and select Properties.

For Windows 8 it is largely the same. Open Task Scheduler by going to Start > Control Panel > System and Security > Administrative Tools > Task Scheduler. It may prompt for an administrator password or confirmation. Click Action, then Create Basic Task. Provide a name for the task, like WaspBackup, then click Next. In this version of the Task Scheduler, you can choose to schedule based on Calendar, common recurring events like When the computer starts, or When a specific event is logged. Coose the appropriate schedule type, then click Next and select Start a program, then Next, then Browse and select BackupDB4MA.bat, then Next and Finish.