cancel
Showing results for 
Search instead for 
Did you mean: 

MS-SQL DB UPGRADE

Former Member
0 Kudos

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

Accepted Solutions (0)

Answers (4)

Answers (4)

former_member184473
Active Contributor
0 Kudos

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

hasanajsh
Active Contributor
0 Kudos

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

Former Member
0 Kudos

Hi Surya,

Are you on which version of SAP ?

Regards,

Nikunj Thaker

Sriram2009
Active Contributor
0 Kudos

Hi Surya

Both Server hardware are different?

Regards

Former Member
0 Kudos

Hi,

No both are same we want to upgrade the MS-SQL DB on that same same server where MS-SQL

2005 is installed and running.

Sriram2009
Active Contributor