SAP recovery

[Former Member]

Dear folks,

my Development server is down. now i am in process of recovery. but i am halt at one stage...

i am doing recovery thro --> Additional Software Life Cycle Task > System Copy -

---

> Target System>Central System--->Based on AS java and AS ABAP -->Central System Installation

while this process it anaysis my exsisting instance perfectly.

while define the parament it as MIGRATION EXPORT.... i didn't find migration export DVD in that pack.

i have only export dvd.

Please give me a idea..

Thanks

Lee green

[former_member204746]

Lee, do you have a backup on tape of this system? If so, why aren't you restoring from that backup?

how severe is your crash? please explain status of your system.

[Former Member]

Hi,

I reinstall the SQL server 2005 due to follow reason....

-

---

i am seeing that all process ended and show the yellow color. So i

restart the SAP

console ...it is not starting.

then i found thro trace file dev_wo, dev_desp that sql server service

have problem.

then i am not able to start the sql service. i find that master db is

missing . so that

the sql server is not stating.

then ... i tried with lot of procedure to recover master db. But all

fails.

so i install sql server 2005 .

then i start the recovery of SAP thro system copy. and

halted in migration export.

-

---

How SQL DB connection is problem while doing EXPORT MIGRATION.

already i attach the BFD DB with sql with windows authorization.

==========================================================

UTL LOAD

-

---

<!LOGHEADER[START]/>

<!HELP[Manual modification of the header may cause parsing problem!]/>

<!LOGGINGVERSION[1.5.3.7185 - 630]/>

<!NAME[UTL_load_usages.log]/>

<!PATTERN[UTL_load_usages.log]/>

<!FORMATTER[com.sap.tc.logging.TraceFormatter(%24d %7s: %m)]/>

<!ENCODING[Cp1252]/>

<!LOGHEADER[END]/>

Sep 6, 2007 4:38:34 PM Info : Successfully parsed!

Sep 6, 2007 4:38:34 PM Info : Executing command Export...

Sep 6, 2007 4:38:34 PM Info : Establishing DB connection...

Sep 6, 2007 4:38:35 PM Path : Exception : The DataBase is down or the connection parameters are wrong: -sid=BFD -dsn=jdbc/pool/BFD -ssprops=G:/usr/sap/BFD/SYS/global/security/data/SecStore.properties -ssk=G:/usr/sap/BFD/SYS/global/security/data/SecStore.key -keyphrase=null

java.lang.Exception

at com.sap.exception.BaseExceptionInfo.traceAutomatically(BaseExceptionInfo.java:1141)

at com.sap.exception.BaseExceptionInfo.<init>(BaseExceptionInfo.java:413)

at com.sap.exception.BaseException.<init>(BaseException.java:302)

at com.sap.sl.ut.infoprovider.exceptions.UTInfoException.<init>(UTInfoException.java:96)

at com.sap.sl.ut.manager.persistence.db.DataBaseInfoFactory.connect(DataBaseInfoFactory.java:215)

at com.sap.sl.ut.manager.persistence.db.DataBaseInfoFactory.constructSystemInfo(DataBaseInfoFactory.java:624)

at com.sap.sl.ut.manager.command.Export.executeExportKDB(Export.java:56)

at com.sap.sl.ut.manager.command.Export.execute(Export.java:80)

at com.sap.sl.ut.manager.command.Command.exec(Command.java:88)

at com.sap.sl.ut.manager.UtlMain.exec(UtlMain.java:60)

at com.sap.sl.ut.manager.UtlMain.main(UtlMain.java:56)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

at java.lang.reflect.Method.invoke(Method.java:585)

at com.sap.engine.offline.OfflineToolStart.main(OfflineToolStart.java:81)

Caused by: java.sql.SQLException: [NWMss][SQLServer JDBC Driver][SQLServer]Login failed for user 'SAPBFDDB'.

at com.sap.nwmss.jdbc.base.BaseExceptions.createException(Unknown Source)

at com.sap.nwmss.jdbc.base.BaseExceptions.getException(Unknown Source)

at com.sap.nwmss.jdbc.sqlserver.tds.TDSRequest.processErrorToken(Unknown Source)

at com.sap.nwmss.jdbc.sqlserver.tds.TDSRequest.processReplyToken(Unknown Source)

at com.sap.nwmss.jdbc.sqlserver.tds.TDSLoginRequest.processReplyToken(Unknown Source)

at com.sap.nwmss.jdbc.sqlserver.tds.TDSRequest.processReply(Unknown Source)

at com.sap.nwmss.jdbc.sqlserver.tds.TDSLoginRequest.submitRequest(Unknown Source)

at com.sap.nwmss.jdbc.sqlserver.SQLServerImplConnection.open(Unknown Source)

at com.sap.nwmss.jdbc.base.BaseConnection.connect(Unknown Source)

at com.sap.nwmss.jdbc.base.BaseConnection.setupImplConnection(Unknown Source)

at com.sap.nwmss.jdbc.base.BaseConnection.open(Unknown Source)

at com.sap.nwmss.jdbc.base.BaseDriver.connect(Unknown Source)

at com.sap.sql.jdbc.NativeConnectionFactory.createNativeConnection(NativeConnectionFactory.java:215)

at com.sap.sql.connect.OpenSQLDataSourceImpl.createConnection(OpenSQLDataSourceImpl.java:522)

at com.sap.sql.connect.OpenSQLDataSourceImpl.getConnection(OpenSQLDataSourceImpl.java:276)

at com.sap.sl.ut.manager.persistence.db.DBConnection.connectViaSecureStore(DBConnection.java:159)

at com.sap.sl.ut.manager.persistence.db.DBConnection.connect(DBConnection.java:171)

at com.sap.sl.ut.manager.persistence.db.DataBaseInfoFactory.connect(DataBaseInfoFactory.java:213)

at com.sap.sl.ut.manager.persistence.db.DataBaseInfoFactory.constructSystemInfo(DataBaseInfoFactory.java:624)

at com.sap.sl.ut.manager.command.Export.executeExportKDB(Export.java:56)

at com.sap.sl.ut.manager.command.Export.execute(Export.java:80)

at com.sap.sl.ut.manager.command.Command.exec(Command.java:88)

at com.sap.sl.ut.manager.UtlMain.exec(UtlMain.java:60)

at com.sap.sl.ut.manager.UtlMain.main(UtlMain.java:56)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

at java.lang.reflect.Method.invoke(Method.java:585)

at com.sap.engine.offline.OfflineToolStart.main(OfflineToolStart.java:81)

Sep 6, 2007 4:38:35 PM Info : Severe (database) error. Return code: 64

============================================================

UTL_JAVA

-

---

java version "1.5.0_06"

Java(TM) 2 Runtime Environment, Standard Edition (build 1.5.0_06-b05)

Java HotSpot(TM) 64-Bit Server VM (build 1.5.0_06-b05, mixed mode)

Regards

jeeva

[Former Member]

Hi,

what about this exception:

Caused by: java.sql.SQLException: [NWMss][SQLServer JDBC Driver][SQLServer]Login failed for user 'SAPBFDDB'

Does the user exist? Also have a look at Note 610640 and Note 592514 (MSSQL: internal database users, permissions and security).

Regards,

Sven

[Former Member]

Hi Lee,

what exactly are you doing?

Did your server crash and you just want to do a restore? Then you have to restore the last full backup and apply transaction logs as needed (point in time). After that you can restart the system.

Are you performing a system copy? If so, then you have to create the MIGRATION EXPORT CD first. Please refer to this document (service.sap.com/instguides):

https://websmp103.sap-ag.de/~sapdownload/011000358700003085942006E/SYSCOPY_2004sSR1_ABAPJava.pdf

On page 27/28 the SQL Server specific procedure is described. But it's always a good idea to read the rest as well

Regards,

Sven