cancel
Showing results for 
Search instead for 
Did you mean: 

How to move database instance to new hardware

jill_diesman
Participant
0 Kudos

Our NW 2004s Portal QA environment is distributed on 3 systems. One system runs SCS and CI, one system is the database instance, and one system is a dialog instance. We're running Windows 2003 and using MSSQL 2000.

We need to move the database instance from its current hardware to different hardware. The only significant difference in the hardware is processing power.

What is the simplest way to move the database instance? Do we have to perform a homogeneous system copy, or is there any easier way?

Best regards,

Jill

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hello Jill,

The simplest way to move database instance is:

- backup Your database

- install DB instance on new machine

- add same user, dba, service users in new instance

- detach database

- attach database in DB new instance

On service.sap.com You can find a SQL script to user and DB copy.

If You don't find I can send You via mail.

Regards,

Marcin Gajewski

Answers (2)

Answers (2)

jill_diesman
Participant
0 Kudos

Thank you, Marcin, your suggestion helped.

We did have an issue after the database move, but are not entirely sure whether it was a direct result of the move. The issue was found when we started JSPM and got the error "Could not find a record with key "admin/user/<SID>" in the store."

In J2EE Config Tool --> Secure Store, we found that 4 keys/rows were missing:

admin/host/<SID>

admin/password/<SID>

admin/port/<SID>

admin/user/<SID>

We added the keys and values and everything worked fine.

Best regards,

Jill

Former Member
0 Kudos

Dear Jill,

I recommend you read the notes:

683447 SAP Tools for MS SQL Server

151603 Copying an SQL Server database

I would recommend you upgrade to SQL 2005 at the same time as you migrate to new hardware.

Please post any question you may have.

Thanks

N.P.C