Skip to Content
avatar image
Former Member

MS-SQL DB UPGRADE

Hi Experts,

Can any one kindly provide me the steps how to upgrade only MS-SQL DB without disturbing current environment.

Current Environment:

OS : Windows 2008

DB : MS-SQL 2005

Target Environment:

OS : Windows 2008

DB : MS-SQL 2008 or 2012.

Regards,

SURYA

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • Feb 20, 2014 at 11:23 AM

    Hi Surya,

    Pls follow the path:

    Choose the version you want to upgrade to and you can find the steps and necessary notes.

    Read the guides carefully.

    What you basically do (as explained) is the SQL Server Upgrade and after that Post Upgrade steps using SAP tools for MS SQL Server and some manual steps.

    You would like to read carefully the guide and notes and firstly upgrade a test system.

    Regards

    Add comment
    10|10000 characters needed characters exceeded

  • Feb 20, 2014 at 12:04 PM

    Hello Surya,

    Check PAM to ensure your product support MSS 2008 or 2012.

    Also, check the following notes and ensure you have the minimum support package before upgrading the DB:

    1076022 - Release planning for Microsoft SQL Server 2008 (R2)

    1651862 - Release planning for Microsoft SQL Server 2012

    Regards,

    Eduardo Rezende

    Add comment
    10|10000 characters needed characters exceeded

  • Feb 20, 2014 at 06:18 AM

    Hi Surya

    Both Server hardware are different?

    Regards

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Feb 20, 2014 at 09:24 AM

    Hi Surya,

    Are you on which version of SAP ?

    Regards,

    Nikunj Thaker

    Add comment
    10|10000 characters needed characters exceeded