Skip Navigation

Install
BlackBerry AtHoc
on a clustered database

To install
BlackBerry AtHoc
on a clustered database or 64-bit
Microsoft SQL Server
platform, complete the following steps:
Contact
BlackBerry AtHoc
customer support to obtain the SQL scripts required for this task.
  1. Set up a staging database server running
    Microsoft SQL Server
    .
  2. Proceed with the installation of the database server on the staging database server, as described in Install the database server.
  3. After the database server installation is complete, back up the new
    BlackBerry AtHoc
    databases on the staging server, and then move the backups from the staging server to the production database server.
  4. Restore the databases on the production database server using the Enterprise Manager or by running the stored procedure dbo.RestoreATPUB from the msdb database. Use the SQL script provided by
    BlackBerry AtHoc
    customer support to create the stored procedure.
  5. Recreate
    BlackBerry AtHoc
    database users by running the stored procedure dbo.ATH_CREATE_USERS from the msdb database. Use the SQL script provided by
    BlackBerry AtHoc
    customer support to create the stored procedure.
  6. Continue with the installation of the application server, as described in Install the application server.