Backup SQL Accounts
This page is for backing up account databases when you're using our SQL Express or SQL Server platforms.
Overview:
You can backup your accounts manually through the user interface and you can backup the databases from the command line prompt.
Manual Backups
1. Confirm that you are running Treasury Software from the same computer that is hosting the SQL Express/Server.
If you are not sure, click on the Settings tab > Maintenance > SQL tab. The SQL server will be listed here.
The SQL Server name should either start with your computer name or be '(local)'.
2. Start Treasury Software in 'Run as Administrator' mode.
You can do this by navigating to the installation directory and right clicking on BRCOM.exe, for example:
C:\Program Files (x86)\Treasury Software\version 2014 01\BRCOM.exe
3. Click File > Backup.
Check the accounts you want to backup and specify the output location of the compressed backup (zip) files.
Click 'Backup Databases' to start the backup
Done with manual backup.
Initiating a Backup from a command line.
1. Confirm that you are running Treasury Software from the same computer that is hosting the SQL Express/Server.
The command line must be triggered from the computer that has both Treasury Software installed on it and that is hosting the SQL Express/Server.
If you are not sure, click on the Settings tab > Maintenance > SQL tab. The SQL server will be listed here.
The SQL Server name should either start with your computer name or be '(local)'.
2. Create a backup using the manual process (above) first to confirm that you have proper rights.
This is critical in confirming local drive permissions.
3. Command line syntax and requirements
The executable TSBackup.exe runs the backup process.
It is located at the default (and should not be moved) installation directory, for example:
C:\Program Files (x86)\Treasury Software\version 2014 01\TSBackup.exe
It accepts 2 parameters (each within double quotations):
Parameter 1 is the path where the files will be backed up,
Parameter 2 is the list of accounts (comma delimited) to be backed up.
Example:
Sample command line with parameters - where the names of the accounts are Checking, Payroll and Depository are written to the folder C:\Backup.:
"C:\Program Files (x86)\Treasury Software\version 2014 01\TSBackup.exe" "C:\Backup" "Checking,Payroll,Depository"
4. Requirements:
The system requires access to write a log file to either (version dependent):
C:\Users\Public\Treasury Software\Logs
C:\Program Files (x86)\Treasury Software\version 2014 01\
Reminder: The computer must already have been successfully connected to SQL Express/Server and be running from the same computer hosting the SQL Express/Server.
5. Set the TSBackup.exe's property to 'Run as Administrator'
Right click on the
C:\Program Files (x86)\Treasury Software\version 2014 01\TSBackup.exe
and select Properties.
Then click on the Compatibility tab > Check 'Run this program as an administrator > Save.
6. Running the command line
You can trigger the command line and parameters from Windows Task Scheduler, a desktop shortcut, a batch file or from any software package that enables you to 'shell out' to the system.
Tip: If you receive any pop-up confirmation windows from the system UAC, you may want to alter the UAC level.
Done. Please let us know if we can help.
