How to move SQL database from one host to another ?

[Former Member]

Hi,

We need to move the database of P1 7.0 from one host to other.Please advice if there are any documents I can refer for this operation.

I believe if we maintain the same host name for the new system it is just database movement and PI should not even be aware of this operation!!

Thanks & Regards

Mrutyunjay

[Former Member]

Hi,

if you are on SQL server database look atr sap note 151603 :Copying an SQL Server database (homogeneous system copy)

if you want to make SAP system copy than consider ABAP+JAVA system copy guide.

if you only want to change/move the DB server your PI system is not start ,

consider following note

Note 8307 - Changing host name on R/3 host: What do you do?

Note 757692 - Changing the hostname for J2EE Engine 6.40/7.0 installation

regards,

kaushal

[Former Member]

Hi,

We have a system R / 3 Enterprise Edition 47x200 running with Microsoft SQL Server 2005.

Copy the BD in another machine (server), then applied script note 551915 (user_restore.sql) and finally proceeded to install the central instance of SAP (sapinst) with existing database option, but it does not appear that the error attached:

Errors during EMP database check on produccion4; reported errors:

Error by Compatibility level check: Database EMP has wrong compatibility level

Error by Dbo objects check: Database EMP contains user objects belonging to system user dbo

; correct reported errors before continuing with the installation

hope someone can give us some help on diagnosing the issues, thaks.

Best regards,

Christian Astete.

[Former Member]

Hi Christian,

Please install SAP first then restore the database backup.

The steps should be

1. Install SAP in new system

2. Drop SAP stored procedures inold database.

3. Copy the datafiles in the new system

4.Detach the new database system. Attatch the old mdf , ndf and ldf files to the new system.

5.Run SAP tools

[Former Member]

Hi,

EMP contains user objects belonging to system user dbo

script is not running successfully.

if you change the SID of system then run user_change script.

regards,

kaushal

[Former Member]

Hi Atrai:

Not much you understand the steps. Please, you can explain more detailed steps to perform this procedure, many thanks.

Best regards,

Christian.

[antonio_voce]

hi cristian , open a new Thread when you post a question so you can assign point.