Finding out Exchnage and SQL SP level through registry or other means.....

Is there a way to tell what Service Pack Level Exchange and SQL are at by looking at the registry? The reason I ask is I am performing a disaster recovery on a SBS03 server using Backup Exec and from what I understand it is critical that both Exchange and SQL be at the same Service Pack level as they were when the failure occured before restoring.  I have already restored the OS partition and it is functioning, but Exchnage and SQL both were installed on another partition. So I hope that there is some way to find this out..... Thx  
hookssystemsAsked:
Who is Participating?
 
dovidmichelConnect With a Mentor Commented:
For SQL
 HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\MSSQLServer\CurrentVersion
0
 
dovidmichelCommented:
Here is the info:

Start Registry Editor (Regedt32.exe).

Locate the following key in the registry:

HKEY_LOCAL_MACHINE\Software\Microsoft\Windows\CurrentVersion\Uninstall

Find the appropriate GUID registry subkey as listed below. Verify that the DisplayName in the right pane equals Microsoft Exchange 2000. The following subkeys indicate the version of Exchange 2000 that is installed on the server:

DB20F7FD-67BC-4813-8808-78F63E89EB56: Standard Version Upgrade Package (VUP)
775CF3DA-C007-4709-B4CC-CE2239BE2E03: Standard Full Packaged Product (FPP)
FC6FA539-452D-4a9b-8065-C1FA74B86F83: Standard Evaluation 120 days (EVAL)
D3574E0C-360A-44d5-858C-33323C2D79F2: Enterprise Version Upgrade Package (VUP)
F8567801-906B-439b-8D6A-87BDFEC9BA52: Enterprise Product Upgrade Package (PUP)
65D9643D-06E8-47d6-865E-80F4CC9BB879: Enterprise Full Packaged Product (FPP)
8B102332-6052-4af3-ADFA-35A3DED0506A: Enterprise Evaluation 120 days (EVAL)

Note: Microsoft does not support attempts to change the value of this registry key. If you change the subkey value, it will not change the version or functionality of the Exchange 2000 software that is installed.

Quit Registry Editor.

Product Version Summary:

Full Packaged Product (FPP): This is a complete product that has no limitations.

Version Upgrade Package (VUP): This is the upgrade only to upgrade from a previous version of the product to the current version (for example, upgrading from Microsoft Exchange Server 5.5 Standard Edition to Exchange 2000 Standard Edition).

Product Upgrade Package (PUP): This is only for a product of the same release (for example, an upgrade from Exchange 2000 Standard Edition to Exchange 2000 Enterprise Edition).

Evaluation Edition (EVAL): This is identical to the FPP version except that it expires 120 days from the date of installation.

0
 
hookssystemsAuthor Commented:
Sorry about not being clearer, but it is Exchange2k3 and I'm looking for the Service Pack level, not that original installed version.
0
 
dovidmichelConnect With a Mentor Commented:
Well it is not in the registry but this Cisco doc recommends checking file properties which might work for you.

http://www.cisco.com/warp/public/788/AVVID/chk-exchg-svs-pck-lvl.pdf
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.