Skip to Content
0
Former Member
Oct 31, 2012 at 11:01 AM

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

76 Views

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.