Step 6. Create a Historical Database

Important

A Historical Database can only be enabled if the production database is on the Enterprise edition or Standard edition of Microsoft SQL Server. It cannot be enabled on a Personal edition server.

A Microsoft hot fix is required on your TADB SQL server before you set up a Historical TADB.

The hot fix is required because of a defect in SQL Native Client,

A described of the defect and an updated version are available at the Microsoft Website:

http://support.microsoft.com/kb/937517

When you use a historical database your project data is stored as follows.

The SQL TADB database:

Holds the following data during production.

Standard attributes.

Extended attributes.

TADB data.

Deletes the data when production is complete.

The Historical database:

Receives all the data that passes through the TADB database.

Note: There may be a 5 second or more delay before the Historical database receives the data. The exact amount of time depends on your system configuration.

Retains all the data that passes through the TADB database.

Note: When data is entered into this database it is read-only; it cannot be deleted.

Keeps an account of all the changes made within any single record.

Therefore, as long as you keep the Historical Database running, you can reference data for any item from the time it started.

Steps to create and use the Historical Database are as follows.

Step 6.1

Create a database in SQL Server

Step 6.2

Specify the database to be the Historical Database.

Step 6.3

Start/stop Historical Database activity.

More information

3.1. Configure the TADB meta-data through the TrackerCfg_UI.