Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

how to restore db backup data file to a remote db server

Hello, everyone

I had one db recovery problem making me headache. Maybe you can give me some hints.

The question is:

1. I have a backup medium file named initdb

2. I can retore it in local computer.

3. I want to restore it to db1 in remote computer by using dbmcli in local computer.

See computer1 is local computer , computer2 as remote computer.

The command series executed in computer1 are like the followiings:

computer1> dbmcli -n computer2 -u dbm,dbm -d db1

dbmcli on computer2: db1> medium_put initialdb_recover
computer1\temp\initdb file data 0 8 no

dbmcli on computer2: db1> db_admin

dbmcli on computer2: db1> db_connect

dbmcli on computer2: db1> db_activate recover initialdb_recover

I got the following errors:

ERR

-24988,ERR_SQL: SQL error

-903,Host file I/O error

6,Data recovery failed

1,Backupmedium #1 (
computer1\temp\initdb) access denied [5]

6,Backup error occured, Errorcode 3700 "hostfile_error"

17,Servertask Info: because Error in backup task occured

10,Job 1 (Backup / Restore Medium Task) [executing] WaitingT72 Result=3700

6,Error in backup task occured, Errorcode 3700 "hostfile_error"

I thought that maybe I need to define a pipe but I can not figure out a way to define it pointing to
computer1\temp\initdb.

Wish your kind help.

Thanks

chu

Former Member
replied

Hi again chu,

the problem here is the Windows authentication.

> 1,Backupmedium #1 (
computer1\temp\initdb) access denied [5]

That error means: the MaxDB Kernelprocess tried to open shared Windowsfile but the user that is running the Kernel does not have the rights to do so.

It's the same user that runs the MaxDB service - usually it's "Local System".

The easiest solution to this may be to create a new user, assign this user access rights to the share and the backup file and run the MaxDB service with this user.

You may also set the parameter "USE_BACKUP_SECURITY_DESCRIPTOR" to NO in order to access the file w/o authentication. But than the share/file permissions have to allow unauthenticated full access to this file.

KR Lars

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question