cancel
Showing results for 
Search instead for 
Did you mean: 

Move DB Instance from one DB server to Another & Keep same DB Instance nam

Former Member
0 Kudos

We currently have too many SAP Databases operation on one MS-SQL database server for our SAP ECC 6.0 environment. I would like some information as to how to move an existing Database from one Database server to another. This move will keep the same DB instance name.

Scenario:

Move DB Instance (QAS) from [Server A] = DB server 1 to [Server B] = DB server 2. Eliminate DB instance from [Server A] DB instance remains QAS. On [Server B]

The ECC 6.0 ABAP+JAVA server is not changing. This runs on a separate host separate from the DB hosts.

The system profiles for both ABAP and JAVA will have to be modified to point to the new DB Server.

Is there a clean process to do this type of move? This process will be used for our u201CTraining, Sandbox, and Development systems as well. The Productions DBu2019s will be the only DBu2019s left on 1 server.

Thanks for your assistance.

Regards,

Bob

Accepted Solutions (0)

Answers (1)

Answers (1)

markus_doehr2
Active Contributor
0 Kudos

> We currently have too many SAP Databases operation on one MS-SQL database server for our SAP ECC 6.0 environment. I would like some information as to how to move an existing Database from one Database server to another. This move will keep the same DB instance name.

Check

Note 151603 - Copying an SQL Server database

Markus