TSA000080

Created By: Jason Painter

Manufacturer: Numara Software

Product: Track-It!

Module: Backup

Version(s): 9, 10

Issue Type: Procedure

Effective as of 9 Mar. 2012

Related: TSA000081 

Backup Procedure

Description

Backing up your database is more involved than simply backing up using Management Studio. A full Track-It! backup includes a number of files that have been changed or created by the user, e.g. configuration files, attachments. This procedure will result in a folder full of files and a standard .bak SQL backup.

Procedure

Download and unzip the TIServerBackup.bat  file to the following directory on the Track-It! Server (default):

C:\Program Files\Numara Software\Numara Track-It!\Track-It! Services\

Open the TIServerBackup.bat file in Notepad.

@ECHO OFF

:: ------------------------------------------------------------------

:: Change the values for the SOURCE system as needed below:

:: MSSQL ONLY ::

SET IntegratedSecurity=false

:: MSSQL and ORACLE ::

SET DBAdminUser=sa

SET DBAdminPassword=TI_DB_P@ssw0rd

SET TISystemRoot=C:\Program Files\Numara Software\Numara Track-It!

SET BackupType=Full

SET Destination=C:\Backups

:: ------------------------------------------------------------------

Within the dashed lines, make sure the parameter values are correct for your environment:

IntegratedSecurity (MSSQL only): true or false. When true, connect to the database server using the current logged on credentials (must be logged on as an administrator of the database server). When false, the database administrator user name and password must be specified.

DBAdminUser: The current database server's database administrator account.

DBAdminPassword: The current database server's database administrator password. The default is shown if Track-It! installed the instance of MSSQL.

NOTE: The backup may fail with an "Invalid Syntax" error if the specified DBAdminPassword contains special characters, such as ^, $, %, etc.

TISystemRoot: Make sure the path is correct for your installation of Track-It!.

The path should be the location where the Track-It! Server and Track-It! Services directories are located on the server. By default, it is set to C:\Program Files\Numara Software\Numara Track-It!.

Please note that if Track-It! is installed on a 64-bit server, the path will contain "(x86)" in it, such as C:\Program Files (x86)\Numara Software\Numara Track-It!.

BackupType: If Full is specified, the applications, configuration files, attachments, and the database will be included. Change this to Database if you only want the database to be included in the backup set. If Components is specified, only the applications, configuration files, and attachments are included.

Destination: The path where the backup set will be created. Please make sure that this path has enough hard drive space to hold the backup of the database. Additionally, make sure the database server itself has enough hard drive space available in the default backup location as a copy of the database backup file will be created there as well.

NOTE: It is recommended that the backup set not be created under any of the Numara Software folders.

 Make sure to change the BackupType value to Database so that only the database backup is included in the backup set. Leaving the default value of Full will also include the applications, configuration files, and attachments which you do not want if you are only moving the Track-It! database to another server.

Make any necessary changes and then save the batch file.

Before beginning the backup make sure everyone has exited out of Track-It!.

 Double-click to run the batch file.

NOTE:

  • If you see a "System error 1060" in regards to a service not existing, you can disregard this error. The batch file attempts to stop and start two services, one of which may not exist on the server, depending on the installation.
  • If other errors occur, a Track-It-Backup.log file, located under the logged on user's %TEMP% directory, can be reviewed.

NOTE: A common mistake when setting up this command is entering an incorrect path for TISystemRoot. This is the path that contains both the Track-It! Services and Track-It! Server folders. If the TISystemRoot path is not correct, the following error will be seen in the log:

"Value cannot be null. Parameter name: value"

 Once the backup is complete, open the destination folder that was specified in the batch file.

Open the Track-It! Backup xxxxxxxxxxxxxx folder and open the Database folder to make sure the backup file exists. If not, the Track-It! server was not able to get the file from the database server due to network or permissions issues.

Open the enclosed Version Details.txt file. Fill out the Track-It! and SQL version details. This is vital if you are sending the backup to a technician, as they need to know this for hosting purposes. Move this file into the Track-It! Backup xxxxxxxxxxxxxx folder.

If you are sending the backup, zip the Track-It! Backup xxxxxxxxxxxxxx folder prior to sending.

The Track-It! Backup xxxxxxxxxxxxxx folder is the complete Track-It! backup.