Error while starting SAP in DR server

[Former Member]

We have created a DR server where we restored the database, changing the host name and without any change in SID. After restoration we tried to start the sap which is throwing the below error.

ERROR: -1 in function CheckCodepageType (SQLExecDirect failed) [line 20831]

C  (208) [42S02] [Microsoft][SQL Server Native Client 10.0][SQL Server]Invalid object name 'DBPROPERTIES'.

B  Connection 0 opened (DBSL handle 0)

C  ERROR: -1 in function StartSelect (execute) [line 14166]

C  (208) [42S02] [Microsoft][SQL Server Native Client 10.0][SQL Server]Invalid object name 'SVERS'.

C  ERROR: -1 in function StartSelect (execute) [line 14166]

C  (8180) [42000] [Microsoft][SQL Server Native Client 10.0][SQL Server]Statement(s) could not be prepared.

B  ***LOG BZA=> table SVERS      does not exist on database            [dblink       1327]

M  ***LOG R19=> ThInit, db_connect ( DB-Connect 004096) [thxxhead.c   1513]

M  in_ThErrHandle: 1

M  *** ERROR => ThInit: db_connect (step 1, th_errno 13, action 3, level 1) [thxxhead.c   11422]

M 

M  Info for wp 0

M 

M 

Kindly suggest us the solution how to solve this issue.

Thanks,

SURYA

[Reagan]

Hello

Check these

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

1294762  - SCHEMA4SAP.VBS

Regards

RB

[Sriram2009]

Hi surya

Kindly refer the SAP Note   1294762  - SCHEMA4SAP.VBS  correct the MS SQl Server schema and than start the SAP system

Regards

Sriram

[Former Member]

Hello Surya,

Please have a look on the note 1907868 - SAP system cannot connect to SQL Server after Alwayson failover.

BR,

K.

[Former Member]

Hello

To make sure whether the SIDs on primary and secondary replicaionts are the same, execute stored procedure "sp_help_revlogin2".

The stored procedure "sp_help_revlogin2"

If the SIDs are different, delete them manually and create again by following "second step " in the above link http://blogs.msdn.com/b/saponsqlserver/archive/2012/03/29/sql-server-2012-alwayson-part-5-preparing-...

Thanks

Shrikant