Skip to Content
author's profile photo Former Member
Former Member

How to move a Netweaver 7.3 WAS Java SQL Server DB to a new SQL Server instance.

I currently have a Netweaver 7.3 Java installation with the SQL Server instance on the same server. An appropriate SQL Server 2008 R2 cluster has become available and for the added security of the data I would like to move the database to the cluster whilst leaving the NW 7.3 Java instance on its existing server. I cannot find satisfactory documentation to support this move and would appreciate if anyone can to add to what I've found so far.

My intention is to: a) shutdown the Java instance b) detach the SQL db from the local SQL instance c) move the data files to the SQL cluster d) attach the SQL db to the SQL cluster instance e) modify the Java instance profile parameters in DEFAULT.PFL i.e. j2ee/dbhost and dbs/mss/server to the SQL cluster's virtual hostname f) restart the Java instance.

I don't know if anything else is required . For example is there anything that needs adjusting in the Java instance configuration.

If anyone has successfully done this then I would be pleased to hear how you achieved it.

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Posted on Nov 10, 2012 at 10:35 PM

    Why don't you follow standart SYstem Copy procedure with DB Specific Method?

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Nov 19, 2012 at 07:41 AM

    In case of Java system, Detach and ataach menthod would be successfull in case where your database(in your case) hostname is same on target and source system. Since you are going to change the hostname so it is not a recommended way to do.

    There is lot of places where database host name are being used at file system level. By the doing troubleshooting you may be able to do movement but during upgrade, definately you will face lot issues.Please follow standrad way of system copy procedure export-import from SAPINST.

    Regards, Premsukh

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.