cancel
Showing results for 
Search instead for 
Did you mean: 

Move SQL Database to another Server

Former Member
0 Kudos

Our SAP landscape is as follows.

SAP BW on WIndows 2003 64 bit with SQL2005 enterprise as DB

SAP EP on WIndows 2003 64 bit with SQL2005 enterprise as DB.

We would like to move the DB instance of both the SAP instances from Existing Central instance to a new machine. Is it possible to do so? if possible pls provide the details.

Regards

Harish

Accepted Solutions (0)

Answers (4)

Answers (4)

Former Member
0 Kudos

Hi Harish!

As already stated, [note 151603|https://service.sap.com/sap/support/notes/151603] explains how to copy a MS SQL Server database. However, I recommend you not to detach the database files under any circumstances! You can obtain the database files to be later attached in the new server just by copying them in the operating system level after having stopped all the database services ( "SQL Server", "SQL Server Agent", etc.); this way if you (hopefully not) have any problems like a physical corruption that you did not detect before, you can still recover most of the data from the database, but attaching the already detached corrupted files will not be possible anymore.

Also some participants in this thread pointed to the Homogeneous System Copy guide specific for your platform (obviously, only the parts regarding the database); get further information on it in the [System Copy and Migration homepage on the SAP Developer Network (SDN)|]. In that page you will find also a direct link to the [Installation Guides|http://service.sap.com/instguidesnw]; the link is referred as System Copy Guides, from which you should follow your SAP release (e.g. SAP NetWeaver 7.0 (2004s) ), then press the link plan and install (under the Installation section) and finally, navigate to the section in which the PDF System Copy guides are (in this example, press 2 - Installation - SAP NetWeaver Systems to display the guides, and download e.g. the System Copy for SAP Systems Based on NW 7.0 SR3 ABAP & Java ).

Following that guide you will be recommended to copy the database with "a database-specific procedure" that is explained in aforementioned note 151603 for MS SQL Server; nevertheless this is not the only method. You could export the database ( with R3trans ), but I would not recommend you that way as it would be very time-consuming. A third method would be to restore a backup of your database in the target host. Check [note 1297986|https://service.sap.com/sap/support/notes/1297986] and its referred notes to learn more on this interesting possibility.

Whatever the method you finally choose, do not dismiss to check [SAP note 193816|https://service.sap.com/sap/support/notes/193816] ( Restore with SQL Server ), as it will help you better understanding what you are trying to do.

If you read the System Copy PDF document very carefully and do not dismiss to check the notes I referred to you, this will be as easy as a pie!

Cheers!

Former Member
0 Kudos

You need to follow the "Homogeneous System Copy Guide" by SAP to accomplish this in the cleanest way possible.

If you have a JAVA or ABAP+JAVA system, you will also need to perform a JAVA EXPORT/IMPORT as well. For that part, you need to follow the SAP Note mentioned in the previous comment above.

I hope this helps.

former_member188883
Active Contributor
0 Kudos

Hi,

Please follow homogenous system copy guide.

In addition to this you will be required to use system copy tool for MSSQL.Details are mentioned in the homogenous system copy guide.

Regards,

Deepak Kori

Former Member
0 Kudos

Please check note: [151603|https://websmp230.sap-ag.de/sap(bD1lbiZjPTAwMQ==)/bc/bsp/spn/sapnotes/index2.htm?numm=151603&nlang=E&smpsrv=https://websmp205.sap-ag.de]

markus_doehr2
Active Contributor
0 Kudos

> We would like to move the DB instance of both the SAP instances from Existing Central instance to a new machine. Is it possible to do so? if possible pls provide the details.

It's technically possible, yes. However, there exists no "step-by-step" documentation to do so.

You can use the detach/attach method (or a full copy) to get your database to the new server but then you'll have to adapt your environmental settings for the users and the Java connections manually.

Markus