Backing up the database automatically - LSM 3.5 SP3 Business + Prof.

Create resp. edit the batch script with a text editor to save the database automatically. Alternatively use the LSM installation toolbox.

The commands and the corresponding timeouts for Smart.XChange and the transponder terminal are optional:

  • net stop Smart.XChangeService /y resp. net start Smart.XChangeService /y
  • net stop TransTermSvr /y resp. net start TransTermSvr /y

You only need those if you actually use the services. Save the file with the extension .bat to the SimonsVoss folder. This batch script performs the following actions:

  1. Stops services which use the database
  2. Removes old backup
  3. Copies database to the backup directory
  4. Restarts services

Content of the batch script:

net stop VNHostSvr /y

timeout /t 30

net stop SVCommNodeSvr /y

timeout /t 30

net stop TransTermSvr /y

timeout /t 30

net stop Smart.XChangeService /y

timeout /t 30

net stop Advantage /y

timeout /t 30

rmdir /s /q C:\SimonsVoss\sv_backup\

md C:\SimonsVoss\sv_backup\

xcopy C:\SimonsVoss\sv_db\*.* C:\SimonsVoss\sv_backup\ /s /c /e

net start Advantage /y

timeout /t 30

net start VNHostSvr /y

timeout /t 30

net start SVCommNodeSvr /y

timeout /t 30

net start TransTermSvr /y

timeout /t 30

net start Smart.XChangeService /y

Instad of the paths C:\SimonsVoss\sv_backup\ and C:\SimonsVoss\sv_db\*.* enter your own paths resp. network paths to your database respectively to your backup directory.

In order to create backups use the Windows built-in task planner to execute this batch script regularly (ideally daily). Select the created script to be executed. No further parameters are necessary.

Please note:

Default settings for security options

  • Execution with the "system" account instead of an administrator account
  • Enable: Execute independently of whether users are logged in or not
  • Enable: Do not save the password
  • Enable: Execute with the highest privileges

Contact your IT department. They are the system owner and therefore responsible for the correct execution of the backup jobs and the archivation of the backups.