Guest User!

You are not Sophos Staff.

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

SGE and SQL2008

We have been asked if its possible to upgrade our enterprise SQL server from 2005 to 2008 without breaking the SafeGuard database.

I have checked the requirements in the SEC documentation but can only find SQL2005 mentioned.  Can anyone tell me if this is possible let alone supported, as I have only just lovingly created and deployed to our environment.

Thanks

:2811


This thread was automatically locked due to age.
  • Found this eventually......... The answer is yes it does.

    The following table lists all supported database server platforms.

    SGN Server - Database Server Support

    SGN 5.40

    SGN 5.50

    Microsoft SQL Server 2005 SP1

    l

    Microsoft SQL Server 2005 Express SP1

    l

    Microsoft SQL Server 2005 SP2

    l

    l

    Microsoft SQL Server 2005 Express SP2

    l

    l

    Microsoft SQL Server 2005 SP3

    l

    l

    Microsoft SQL Server 2005 Express SP3

    l

    l

    Microsoft SQL Server 2008 SP1

    l

    Microsoft SQL Server 2008 Express SP1

    l

    :2812

  • SyrianHamster wrote:

    We have been asked if its possible to upgrade our enterprise SQL server from 2005 to 2008 without breaking the SafeGuard database.

    I have checked the requirements in the SEC documentation but can only find SQL2005 mentioned.  Can anyone tell me if this is possible let alone supported, as I have only just lovingly created and deployed to our environment.

    Thanks


    Hi SyrianHamster!!

    Please remember to backup your database prior to the upgrade to MS SQL 2008. Yes, you should be able to upgrade MS SQL Server 2005 to 2008.

    As a side note for anyone else, you can upgrade SQL Express 2005 or 2008 to the full version of MS SQL 2005 or 2008 (Standard or Enterprise). I've done that when it was only the same year version and it went well. Meaning

    Express 2005 -> 2005   or

    Express 2008 -> 2008

    I've never upgraded SQL Express 2005 to MS SQL 2008. Has anyone ever done that with success?

    :2851