Thread Info
  • State Verified Answer
  • Locked Locked
  • Replies 4 replies
  • Subscribers 1 subscriber
  • Views 4258 views
  • Users 0 members are here
Options
Suggested
This discussion has been locked.
You can no longer post new replies to this discussion. If you have a question you can start a new discussion

Installation SQL Service Packs and Patches

Manaburner

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

:28027


This thread was automatically locked due to age.
Parents
  • 0

    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

    :28029
Reply
  • 0

    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

    :28029
Children
No Data