TUG-Libraries Staff Web StaffWeb: UG | UW | WLU
Libraries: UG | UW | WLU
Campus: UG | UW | WLU
Home Documents  
Documents Contacts Search

TUG Statistics & Reports

Cognos Web Server Backup and Restore Procedures

The following document outlines the procedures for backing up and restoring the files necessary for the Cognos Web Servers.

There are two Cognos Web Servers. The test server is called “reports.lib.uwaterloo.ca”. The production server is called “tugrprts.lib.uwaterloo.ca”.

On each server there is a folder c:\BACKUPS which contains the files necessary to restore the servers. The table below describes the files and folders in c:\BACKUPS.

File/Folder Name

Description

Backup.bat

The main backup batch

Lib.lae

The authentication file used by the Cognos web servers

IWRDbBackup.bak

The IWR datastore database backup

UpfrontStore.bak

The UpFront datastore backup

Inc.lst

Created by the batch backup.bat

Ppes.ccp

Used in the batch backup.bat to start the PowerPlay Server

Import_list.txt

Used by the batch backup.bat to create the IWR datastore database backup

Ppesstop.ccp

Used in the batch backup.bat to stop the PowerPlay Server

Locale.tab

TUG customized version of Cognos file

Iwrstart.xml

Used by the batch backup.bat to start the IWR server

Iwrstop.xml

Used by the batch backup.bat to stop the IWR server

PPSRoot.cfx

A file copied from f:\Program Files\Cognos\cer3\ppserver by the batch backup.bat

PPSRoot

A folder copied from from f:\Program Files\Cognos\cer3\ppserver by the batch backup.bat

The batch “backup.bat” is scheduled to run on a daily basis at 2:00 am. The IWR and PowerPlay Servers are taken down during the batch for a brief period.

In the event that a restore is necessary follow the procedures outlined below;

  1. Ensure that the Cognos Upfront services (Administration, Data Store and Dispatcher) are running. (Right click on “My Computer”, select “Manage” , then select “Services and Applications”, then select “Services”)
  2. Run the batch C:\BACKUPS\restore1.bat
  3. Ensure that the Cognos IWR Service Manager and Cognos PowerPlay Enterprise Server are stopped
  4. Run the batch C:\BACKUPS\restore2.bat
  5. From the most recent backup tape prior to the event necessitating the restore, restore the following;
    1. F:\IWR_Reports\Acquisitions
    2. F:\IWR_Reports\circ_transactions
    3. F:\IWR_Reports\circulation
    4. F:\IWR_Reports\fine_fee
    5. F:\IWR_Reports\holds
    6. G:\PP_Cubes
  6. Run the batch C:\BACKUPS\restore3.bat
http://staff.tug-libraries.on.ca/trellis_reports/backup.html
Last updated: November 28, 2003