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	emp\sophos51.bak .\sophos SOPHOS51 C:\sec_51\ServerInstaller\DB\Core\backupdb.bat  C:\Windows	emp\sophospatch51.bak .\sophos SOPHOSPATCH51 C:\sec_51\ServerInstaller\DB\Core\backupdb.bat C:\Windows	emp\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 :28029