Skip Navigation

Install 
BlackBerry AtHoc
 on a clustered database

To install 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 procedure.
  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 
    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 
    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.