Description of the cumulative update package for Office Communications Server 2007 R2 database: July, 2010

Applies to: Microsoft Office Communications Server 2007 R2

Summary

This article describes the Office Communications Server 2007 R2 database issues that are fixed in the cumulative update package for Microsoft Office Communications Server 2007 R2 that is dated July, 2010.

Note Additionally, this update package applies to the Microsoft SQL Server scripts in Office Communications Server 2007 R2.

This article describes the following items about the update package:

The issues that the update package fixes.
The prerequisites for installing the update package.
Whether you must restart the computer after you install the update package.
Whether the update package is replaced by any other update package.
Whether you must make any registry changes.
The files that the update package contains.

INTRODUCTION

This cumulative update also includes the following previously released update:

983567 The update process fails when you install the cumulative update package that is described in KB article 979857
981215 Chat channels become unavailable in Office Communications Server 2007 R2 Group Chat client
981247 Office Communication Server 2007 R2 and SQL Server report frequent SQL deadlocks
972725 Error message when you try to join a “My Meeting” conference in Communications Server 2007 R2: "sorry; unable to transfer you into the conference"
978377 Error message when you install the Office Communications Server 2007 R2 database update package that is dated July, 2009: "Error 1722"
978362 You experience performance issues in Office Communications Server 2007 R2 when many legacy presence users are converted to enhanced presence users at the same time

More Information

You must install the cumulative update that is described in this article. Otherwise, the Office Communications Server 2007 R2 services may not start after you install the following cumulative update:

983472 Description of cumulative update for Office Communications Server 2007 R2: July, 2010

Update package information

Microsoft Download Center

The following file is available for download from the Microsoft Download Center:

Download the OCS2009-DBUpgrade.msi package now.

Release Date: July 2010

For more information about how to download Microsoft support files, click the following article number to view the article in the Microsoft Knowledge Base:

119591 How to obtain Microsoft support files from online services

Microsoft scanned this file for viruses. Microsoft used the most current virus-detection software that was available on the date that the file was posted. The file is stored on security-enhanced servers that help prevent any unauthorized changes to the file.

By contacting support

A supported hotfix is available from Microsoft. However, this hotfix is intended to correct only the problems that are described in this article. Apply this hotfix only to systems that are experiencing the problems described in this article. This hotfix might receive additional testing. Therefore, if you are not severely affected by this problem, we recommend that you wait for the next software update that contains this hotfix.

If the hotfix is available for download, there is a "Hotfix download available" section at the top of this Knowledge Base article. If this section does not appear, contact Microsoft Customer Service and Support to obtain the hotfix.

Note If additional issues occur or if any troubleshooting is required, you might have to create a separate service request. The usual support costs will apply to additional support questions and issues that do not qualify for this specific hotfix. For a complete list of Microsoft Customer Service and Support telephone numbers or to create a separate service request, visit the following Microsoft Web site:

http://support.microsoft.com/contactus/?ws=support

Note The "Hotfix download available" form displays the languages for which the hotfix is available. If you do not see your language, it is because a hotfix is not available for that language.

Prerequisites

To apply this update package, you must have the following applications installed:

Office Communications Server 2007 R2 Administration Tools
SQL Client Tools
If you install SQL 2008 Client Tools, you must also install SQL 2005 SP2 Backward Compatibility.

Before you install this update, Office Communications Server Front End Service (rtcsrv) must be stopped.

Restart requirement

You may have to restart the computer after you apply this update package.

Update package replacement information

This hotfix package replaces hotfix package 983568.

983568 Description of the cumulative update package for Office Communications Server 2007 R2 database: May, 2010

Registry information

To use one of the update packages in this package, you do not have to make any changes to the registry.

Update package installation information

Note Before you install this update, Office Communications Server Front End Service (rtcsrv) has to be stopped.

Installation information depends on the server role that you apply the database update to.

Communications Server 2007 R2 Standard Edition

Install this update on any of the following servers that are running Office Communications Server 2007 R2:

Standard Edition Server
Director (Standard Edition)

To install this update, run the OCS2009-DBUpgrade.msi file directly.

Office Communications Server 2007 R2 Enterprise Edition (EE)

You can install the database update from the Office Communications Server 2007 R2 Enterprise Edition back-end, or from the Office Communications Server 2007 R2 Enterprise Edition front-end. However, we recommend that you install the database update from the Office Communications Server 2007 R2 Enterprise Edition back-end.

To install the database update for Office Communications Server 2007 R2 Enterprise Edition, type the following command:

OCS2009-DBUpgrade.msi POOLNAME=Poolname

Where Poolname is the Enterprise Edition Pool name.

Note If you have moved the database from a server that is running office Communications Server 2007 R2 (Back-End) that had update 2032834 installed to a new server that is running Communications Server 2007 R2 (Back-End), you must reapply update 2032834 to the new server.

Removal information

This update cannot be removed. To remove the update, you must remove and then reinstall Communications Server 2007 R2. The following instructions only help you remove the update listing from Add or Remove Programs in Control Panel.

Office Communications Server 2007 R2 Standard Edition

Remove the update listing for this update package from Add or Remove Programs on any of the following servers that are running Office Communications Server 2007 R2:

Standard Edition Server
Director (Standard Edition)

To remove the update listing for this update package from
Add or Remove Programs, run the OCS2009-DBUpgrade.msi file.

Note Click OK when you receive the following message:

Warning 25000. This update package made changes to the database schema that cannot be removed. If you proceed, you will remove the update package from the Add/Remove Programs list, but the changes will remain in the database schema. Do you want to proceed?

Office Communications Server 2007 R2 Enterprise Edition

Remove the update listing for this update package from
Add or Remove Programs on any of the following servers that are running Office Communications Server 2007 R2:

Enterprise Edition (Back-end)
Director (Enterprise Edition) Back-end

To remove the update listing for this update package from
Add or Remove Programs from the back-end of a Microsoft SQL Server server, run the following command:

OCS2009-DBUpgrade.msi POOLNAME=poolname

Where Poolname is the Enterprise Edition Pool name.

Note Click OK when you receive the following message:

Warning 25000.This update package made changes to the database schema that cannot be removed. If you proceed, you will remove the update package from the Add/Remove Programs list, but the changes will remain in the database schema. Do you want to proceed?

File information

This update may not contain all the files that you must have to fully update a product to the latest build. This update contains only the files that you must have to correct the issues that are listed in this article.

After the update is installed, the global version of this update has the file attributes, or a later version of the file attributes, that are listed in the following table:

File name	File version	File size	Date	Time	Platform
Dbcommon.sql	Not Applicable	20,226	29-Jun-2009	11:55	Not Applicable
Dbqfeupdate.wsf	Not Applicable	11,847	30-Jun-2010	08:06	Not Applicable
Dbrtc.sql	Not Applicable	1,088,267	30-Jun-2010	13:47	Not Applicable
Dbrtcdyn.sql	Not Applicable	28,793	30-Jun-2010	13:47	Not Applicable
Dbsetup.wsf	Not Applicable	108,595	30-Jun-2010	13:47	Not Applicable
Dbupgrade.wsf	Not Applicable	38,934	29-Jun-2009	06:29	Not Applicable
Roles.sql	Not Applicable	838	30-Jun-2010	13:47	Not Applicable
Types.sql	Not Applicable	541	30-Jun-2010	13:47	Not Applicable

References

For more information about software update terminology, click the following article number to view the article in the Microsoft Knowledge Base:

824684 Description of the standard terminology that is used to describe Microsoft software updates

For more information about the latest updates for Communications Server 2007 R2, click the following article number to view the article in the Microsoft Knowledge Base:

968802 Updates for Communications Server 2007 R2

Last Updated: Sep 17, 2018