Archiving collocated with OCS std edition server + SQL Express Edition collocated with SQL 2005 server SP2 on same OCS std edition server RRS feed

  • Question

  • Hi

    We have a small deployment for about 100 users and we want to collocate archiving server with ocs std edition server.
    Can we install SQL Express Edition collocated with SQL 2005 server SP2 on same OCS std edition server ??

    Friday, May 15, 2009 8:47 AM

All replies

  • Here's the database collocation statement from the OCS documentation:

    Collocation of the archiving database is supported on both Standard Edition servers and Enterprise Edition Front End Servers; however, we do not recommend collocation on Standard Edition servers because of the potential impact on performance. Collocation of the Archiving and CDR Database with the Back-End Database for an Enterprise Pool is not supported.

    But because mixing SQL Server Standard/Enterprise with SQL Server Express on teh same host is a bad idea it's much better to install an additional SQL Express instance on the Standard Edition Server to store the Archving/CDR database.

    For R2 the same approach can be used for the Archiving Server database.  You can manually reinstall SQL Express 2005 for it's own setup files (not the OCS setup wizard) and install a new named instance.  I beleive up to 16 instances are supported for SQL Express on the same host.

    Jeff Schertz, PointBridge | MVP | MCITP: Enterprise Messaging | MCTS: OCS
    Friday, May 15, 2009 12:14 PM
  • If we had already installed SQL Express 2005 from the OCS  setup wizard;
    can we install later on a new SQL Express 2005 from it's own setup files with a new named instance?
    Is  SQL Express 2005 supported for archiving and cdr?

    Friday, May 15, 2009 12:31 PM