How to manually upgrade Spotlight on Messaging 7.4 database to 7.5 on both clustered and non-clus (4219600)

How to manually upgrade Spotlight on Messaging 7.4 database to 7.5 on both clustered and non-clustered SQL 2005 & SQL 2008 Servers

IMPORTANT NOTES:

- These steps are known to work successfully; however, they have not been officially tested by Quest Software Quality Control.

- If any of these instructions are changed, this solution becomes unsupported by Quest Support and Development. For customization of the Quest Spotlight on Messaging product, please contact our Professional Services Organization:http://www.quest.com/professional-services.

The steps to manually upgrade the SoM database can be found in more detail on page 22 of theSpotlight on Messaging Deployment Guide

Theses teps are also outlined below:

To manually upgrade the Spotlight on Messaging 7.4 database:

1. From the location where you extracted the Spotlight on Messaging 7.5 installation package, copy the following folder to the SQL server that hosts the SpotlightManagementFramework database: \DatabaseScripts\UpgradeScripts
2. Open SQL Server Management Studio
3. Make a backup of your current SpotlightManagementFramework database
4. From SQL Server Management Studio click File | Open | File and browse to the location where you copied the UpgradeScripts folder from step 1. Open the 74_to_741 folder and open and run the following SQL scripts against the SpotlightManagementFramework database in the following order:
   • UpgradeSchema2.sql
   • UpgradeData.sql
5. Click File | Open | File, open the 741_to_75 folder and open and run the following SQL scripts against the SpotlightManagementFramework database in the following order:
   • UpgradeSchema1.sql
   • UpgradeSchema2.sql
   • UpgradeData.sql
6. Once the database has been upgraded, log into the Spotlight on Messaging server using the Spotlight on Messaging service account
7. Run the installer, select Custom and do not select the database portion
8. Once Spotlight on Messaging has been upgraded to 7.5, install the new license:
   • Open Spotlight on Messaging console
   • Navigate to the top node of tree - Spotlight on Messaging
   • Select the Plug-In Information Tab
   • Right click the Exchange component and click Update License