How to backup and restore Track-It! 11.x using TI.exe

Version 3
    Share:|

    This document contains official content from the BMC Software Knowledge Base. It is automatically updated when the knowledge article is modified.


    PRODUCT:

    Track-It!


    APPLIES TO:

    BMC Track-It!



    PROBLEM:

    How do I backup and restore the Track-It! system in case of a system failure?


    SOLUTION:

    TI.exe is a command line utility that can be used to create a backup set of the Track-It! system, including a backup of the database, configuration files, and file attachments. In addition, the utility can be used to recover the Track-It! system from a saved backup set.

    NOTE on 64-bit Servers: Prior to beginning any backup or restore operation, if the Track-It! server runs a 64-bit version of Windows, it will be necessary to install some prerequisites.

       
    1. These prerequisites are only needed if the Track-It! server is running a 64-bit operating system.
    2.  
    3. Although these installers reference SQL Server 2008, these files have nothing to do with the actual database server, or version of Microsoft SQL Server that is in use by Track-It!, and are required in order to run the backup and restore process from the Track-It! server.
      
      Install the following files in the order shown below on the 64-bit Track-It! server:  
        1. SQL Server System CLR Types for 64-bit 
       
        http://go.microsoft.com/fwlink/?LinkId=123722&clcid=0x409
        
       
        2. SQL Server Management Objects for 64-bit 
       
        http://go.microsoft.com/fwlink/?LinkId=123709&clcid=0x409
        
       
       
        How to Create a Track-It! Backup Set:
        
         
      1. Download the attached file TIA06202.zip from the Attachments section below, which contains a batch file that will allow you to create a backup set.
      2.  
      3. Extract the files to the following directory (default 32-bit):
        
        Track-It! 11.x upgrades from versions prior to 11    C:\Program Files\Numara Software\Numara Track-It!\Track-It! Services 
       
        Track-It! 11.x new    C:\Program Files\BMC Software\Track-It!\Track-It! Services
        
         
      1. Open the TIServerBackup.bat file with Notepad.
        
        The following appears: 
         
        @ECHO OFF
      set home=%~dp0
      cd %home%

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

      SET IntegratedSecurity=false

      SET DBAdminUser=sa
      SET DBAdminPassword=TI_DB_P@ssw0rd SET

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

      SET BackupType=Full

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

      NET STOP TIServiceManagement
      NET STOP TIPasswordReset

      ECHO Please wait while the Track-It! system is backed up...

      ti Backup SystemRoot="%TISystemRoot%" DatabaseAdminUserName=%DBAdminUser% DatabaseAdminPassword=%DBAdminPassword% UseIntegratedSecurity=%IntegratedSecurity% BackupOption=%BackupType% ServerBackupOption=Full Destination="%Destination%"

      NET START TIServiceManagement
      NET START TIPasswordReset

      pause
       
       
        
        
          
        
          
        
        4. Within the dashed lines, make sure the parameter values are correct for your environment:  
       
        IntegratedSecurity - "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 database server's database administrator account.  
       
        DBAdminPassword - The database server's database administrator password. Default is shown.  
       
        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!, however, if you had installed Track-It! 11 fresh, the path will be C:\Program Files\BMC Software\ 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)\BMC Software\Track-It!.  
       
        BackupType - Should be one of the following: 
        
       
      a.    Full (default) - The database, configuration files and attachments are included in the backup set.  
       
      b.    Database - Only the database is included in the backup set.  
       
      c.    Components - Only the configuration files and attachments are included in the backup set.   

       

        
        
       
       
        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, in addition to any file attachments that exist in Track-It! (if a Full or Components backup is done). 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 or    BMC Software folders. 
        
       
      5. Make any necessary changes and then save the batch file. 
        
        6. Before beginning the backup make sure everyone has exited out of Track-It!. 
        
        7. Double-click to run the batch file.  
       
        NOTE: If any errors occur, a    Track-It-Backup.log file, located under the logged on user's    %TEMP% directory, can be reviewed. 
        
       
      8. Once the backup is complete, open the destination folder that was specified in the batch file. 
        
        9. Open the    Track-It! Backup xxxxxxxxxxxxxx folder (known as a "backup set") and open the    Database folder to make sure the database 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. 
        
        10. Save the entire    Track-It! Backup xxxxxxxxxxxxxx folder to a secure location in case it is needed for disaster recovery.  
       
        Important!: In addition to creating the backup set, make sure to also backup the    WOATTACH folder under    ..\BMC Software\Track-It!\Track-It! Server if it exists. This folder contains all attachments if you had ever migrated from Track-It! 7. If this folder is not backed up separately and a restore of your backup set is needed, these files will be lost.  
       
        How to Restore Track-It! from a Backup Set
        
       
      1. Install Track-It! 11. 
        
        2. Copy the backup set (ie.    Track-It! Backup xxxxxxxxxxxxxx) to the desired location on the server. 
        
        3. Download the attached file TIA06202.zip from the Attachments section below, which contains a batch file that will allow you to restore from backup (if you did not already obtain it ealrier to create the backup). 
        
        4. Extract the files to the following directory (default 32-bit): 
        
       
        Track-It! 11.x upgrades from versions prior to 11 
        C:\Program Files\Numara Software\Numara Track-It!\Track-It! Services 
       
        Track-It! 11.x new 
        C:\Program Files\BMC Software\Track-It!\Track-It! Services
        
       
      5. On the server, open the    TIServerRestore.bat file, located in the    Track-It! Services folder, with Notepad.  
       
      The following appears:  
       
        @ECHO OFF

      set home=%~dp0
      cd %home%

      :: ------------------------------------------------------------------
      :: Change the values for the DESTINATION system as needed below:

      SET IntegratedSecurity=false

      SET DBAdminUser=sa

      SET DBAdminPassword=TI_DB_P@ssw0rd
      SET DBServer=Server01

      SET DBName=TRACKIT_DATA
      SET TISystemRoot=C:\Program Files\BMC Software\Track-It!

      SET BackupSetLocation=C:\Backups\Track-It! Backup 20110503012734

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

      NET STOP TIServiceManagement
      NET STOP TIPasswordReset

      ECHO Please wait while the Track-It! system is restored...

      ti Restore SystemRoot="%TISystemRoot%" DatabaseServerName=%DBServer% DatabaseName=%DBName% DatabaseType=SQLServer DatabaseAdminUserName=%DBAdminUser% DatabaseAdminPassword=%DBAdminPassword% UseIntegratedSecurity=%IntegratedSecurity% BackupSetLocation="%BackupSetLocation%"

      NET START TIServiceManagement
      NET START TIPasswordReset

      pause
        
       
      6. Within the dashed lines, make sure the parameter values are correct for your environment:  
       
        IntegratedSecurity - "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 database server's database administrator account.  
       
        DBAdminPassword - The database server's database administrator password.  
       
        DBServer - The name of the database server, or    %Database Server\   InstanceName% if using a named instance of Microsoft SQL Server, where the database will be restored.  
       
        NewDBName - The name of the new database that will be restored. The new database name must not already exist on the destination system, or in the specified named instance.  
       
        TISystemRoot - The path where the Track-It! Server and Track-It! Services directories are located on the Track-It! server.  
       
        BackupSetLocation - The full path of the backup set on the Track-It! server. 
        
       
      7. Make any necessary changes and then save the batch file. 
        
        8. Double-click to run the batch file.  
       
        NOTE: If any errors occur, a    Track-It-TI.log file, located under the logged on user's    %TEMP% directory, can be reviewed. 
         
        9. Once the restore process has completed, run Technician Client to make sure it logs in properly. 
        
        10. Finally, install Technician Client on the technician machines from the Track-It! server's shared installers directory:  
       
      ie. \\   %TIServer%\TrackIt\Installers\TechnicianClient\en 
        
        

       


      Article Number:

      000009878


      Article Type:

      Solutions to a Product Problem



        Looking for additional information?    Search BMC Support  or  Browse Knowledge Articles