on 02-20-2014 5:27 AM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Surya,
Are you on which version of SAP ?
Regards,
Nikunj Thaker
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Surya
Both Server hardware are different?
Regards
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Surya
Kindly refer the SAP Note
1676665 - Setting up Microsoft SQL Server 2012
683447 - SAP Tools for MS SQL Server
Regards
Ram
User | Count |
---|---|
94 | |
11 | |
10 | |
9 | |
9 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.