Database not Up after restoring another server Backup

[Former Member]

HI All

I have restore SAP MSSQL Database 2005 from a different server after restoring i facing issue. DB is not connecting.

while i am running R3trans -d following is log:-

This is R3trans version 6.14 (release 700 - 16.10.08 - 16:26:00)

unicode enabled version

2EETW169 no connect possible: "DBMS = MSSQL

ER = 'KUDSPROD' DBNAME = 'KUP'"

R3trans finished (0012).

And dispatcher error is following:-

• ERROR => NiIRead: SiRecv failed for hdl 4 / sock 1392

(SI_ECONN_BROKEN/10054; I4; ST; 127.0.0.1:1218) [nixxi.cpp 4424]

DpJ2eeMsgProcess: j2ee state = CONNECTED (NIECONN_BROKEN)

DpIJ2eeShutdown: send SIGINT to SAP J2EE startup framework (pid=388)

• ERROR => DpProcKill: kill failed [dpntdisp.c 371]

DpIJ2eeShutdown: j2ee state = SHUTDOWN

Wed Mar 23 22:17:49 2011

my types changed after wp death/restart 0xbf --> 0xbe

my types changed after wp death/restart 0xbe --> 0xbc

my types changed after wp death/restart 0xbc --> 0xb8

my types changed after wp death/restart 0xb8 --> 0xb0

my types changed after wp death/restart 0xb0 --> 0xa0

my types changed after wp death/restart 0xa0 --> 0x80

• DP_FATAL_ERROR => DpWPCheck: no more work processes

• DISPATCHER EMERGENCY SHUTDOWN ***

increase tracelevel of WPs

NiWait: sleep (10000ms) ...

NiISelect: timeout 10000ms

NiISelect: maximum fd=1533

NiISelect: read-mask is NULL

NiISelect: write-mask is NULL

Wed Mar 23 22:17:59 2011

NiISelect: TIMEOUT occured (10000ms)

dump system status

Workprocess Table (long)

Regards

YogRaj

[sivakumar_kilari3 · Accepted solution]

Hi,

Read this SAP note:

Note 551915 - R/3 won't start after database restore or database copy

Thanks

Siva

[former_member184473]

Hello,

Maybe this is a problem with the users.

Check note [1294762|http://service.sap.com/sap/support/notes/1294762].

Regards,

Eduardo Rezende

[Former Member]

HI i have resolved the problem with the help of note 551915. Script is attached with this note i have replaced users.

Thanks

YogRaj