IMPAX 6.5.1 Server Knowledge Base home

SQL Server home

The Database Server controls the entire IMPAX cluster. The IMPAX Database Server can run on either Microsoft SQL Server or Oracle software.

Understanding SQL Server

What is the IMPAX Database Server?

SQL database: Key concepts

Monitoring the database

Running osql to access SQL Server data

Determining the version of SQL Server that is installed

Monitoring SQL database and transaction log space usage

Monitoring SQL 2005 database activities

Monitoring SQL 2008 database activities

Restoring the database

Database recovery considerations

Restoring the SQL databases

Restoring the SQL databases when differential or incremental backup jobs are enabled

Backing up the database

Determining database backup needs for your site

Determining what type of backup to perform

Manually backing up the SQL database

Scheduling additional SQL database backup jobs

Enabling the SQL differential and incremental backup jobs

Verifying that the SQL database was backed up correctly

Maintaining the database

Determining the indexes on a SQL table

Scheduling the defragmentation job to rebuild SQL 2005 or SQL 2008 database indexes

Troubleshooting

Troubleshooting: SQL Server database


Topic number: 8853

Applies to: IMPAX 6.5.1 Server Knowledge Base