locked
MOSS2007 on SQL2008 Standard - Upgrade to SP3 RRS feed

  • Question

  • Hi,

    I'm wondering if there are any known issues with MOSS2007 when updating SQL2008 to SP3, or if there is a specific pre-upgrade check I need to perform? I understand there may be a need to backup databases and the 12 hive perhaps, but other than this I am unsure of the process, as I cannot find any compatibility matrices, etc relating to MOSS and SQLServer Service packs.

    Thanks.

    Wednesday, July 24, 2013 3:32 PM

Answers

All replies

  • Hi,

    Thank you for your question. I am trying to involve someone familiar with this topic to further look at this issue. There might be some time delay. Appreciate your patience. Thank you for your understanding and support.

    Thanks,

    Entan Ming

    TechNet Subscriber Support in forum

    If you have any feedback on our support, please contacttnmff@microsoft.com.


    Entan Ming
    TechNet Community Support

    Thursday, July 25, 2013 2:48 AM
    Moderator
  • Hi kludger,

    Recycling some old bits as this seems already discussed.

    http://social.technet.microsoft.com/Forums/sharepoint/en-US/e38cd162-7f7f-454a-9628-0d18f79f3bc2/sharepoint-2007-and-sql-2008-sp3-on-windows-server-2008-enterprise-sp2-64bit

    Having said that, here is the MSDN article that lists what SQL version can be the DB for a MOSS 2007 Farm Installation

    http://technet.microsoft.com/en-us/library/cc262485(v=office.12).aspx#section2 (check the Database Server section under the Server Farm Installation section) which states that MOSS 2007 Sp1+ is needed for SQl 2008+ and MOSS 2007 Sp2+ is needed for SQL 2008 R2+ , hope that clarifies. Thats a general supportability match up but any known specific issues shall be documented as specific KB articles (in general).

    As for any known issues, only list I am aware of is this

    http://social.technet.microsoft.com/wiki/contents/articles/4937.microsoft-sql-server-2008-sp3-release-notes.aspx

    but as you can see there is nothing about SharePoint there, it is still a list of issues you should read about and understand before you upgrade SQL 2008 to SP3.

    More importantly - as always recommended - any upgrade on SharePoint or SQL side you want to perform in your Production SharePoint farm, should be preceded by

    1. testing the same upgrade in a non production test/dev/staging farm which is more or less a replica of your production farm.

    2. As for backups, if possible you should have a full SharePoint backup but at the least backup the content DBs, SSP DBs from SQL side and document the exact steps of redoing all your SharePoint customizations (solutions, features, where are solution files, assemblies etc, steps on how you deploy them on a fresh SPS Server etc) should , web application settings, AAMs, SSP settings.

    Regards,

    Sukesh.

    Tuesday, July 30, 2013 11:03 AM