Installation SQL Service Packs and Patches

Question

Hi all,

we're running the Sophos Enterprise Console 5.1 with the bundled MS SQL 2008 Express database server. Is it safe to install SQL Service Packs and patches for that version, as long as the SP level is listed here http://www.sophos.com/en-us/support/knowledgebase/113278.aspx ?

Regards,

Michael

This thread was automatically locked due to age.

jak · Accepted Answer

HI,

Sure, you could even upgrade it to SQL Express 2008 R2.

http://www.microsoft.com/en-us/download/details.aspx?id=23650

The steps being:

Step 1: Download and install Microsoft .Net Framework 3.5 SP1. [DONE - Came with SEC]
Step 2: Download and install Windows Installer 4.5. [DONE - Came with SEC]
Step 3: Download and install Windows PowerShell 1.0. [Probably a TODO]
Step 4: Download SQL Server 2008 R2 Express with Management Tools by clicking the appropriate link below.

SQLEXPRWT_X86 Executable
SQLEXPRWT_X64 Executable

You only need Powershell for the management tools but I think they're worth having inorder to run queries/ad-hoc reports against the database to get the most out of the data, etc...

EDIT: I forgot to mention, it's always worth backing up the databases first. Just using BackupDB.bat will do. So essentially:

1. Stop the services:

"Sophos Management Service"
"Sophos Patch Server Communicator"
"Sophos Encryption Business Logic Service" (If exists)

2. Run:

C:\sec_51\ServerInstaller\DB\Core\backupdb.bat C:\Windows\temp\sophos51.bak .\sophos SOPHOS51

C:\sec_51\ServerInstaller\DB\Core\backupdb.bat C:\Windows\temp\sophospatch51.bak .\sophos SOPHOSPATCH51

C:\sec_51\ServerInstaller\DB\Core\backupdb.bat C:\Windows\temp\sophosenc51.bak .\sophos SOPHOSENC51

There are a number of tools that might also be interesting to you:

http://www.microsoft.com/en-us/download/details.aspx?id=16978

For now, this is probably the most relevant.

Microsoft® SQL Server® 2008 R2 Upgrade Advisor

Microsoft SQL Server 2008 R2 Upgrade Advisor analyzes instances of SQL Server 2000, SQL Server 2005 and SQL Server 2008 in preparation for upgrading to SQL Server 2008 R2. Upgrade Advisor identifies feature and configuration changes that might affect your upgrade, and it provides links to documentation that describes each identified issue and how to resolve it.

Regards,

Jak