Restoring MaxDB from a Network Drive?
currently we are working on a system refresh (Windows 2008 R2 + MaxDB) with SWPM10 as <SID>adm.
At the moment we are stuck at the restore in the MaxDB Database Studio. At the point when the SWPM tells us to "Use the DBMGUI to perform a database recovery..." we tried to do this.Our backup files are waiting on a network drive.
In DB Studio via Administration Tasks -> Recovery we set up a new parallel backup template. We put the Path "X:\PRDBr\PRD_COM_0" Under "Device/File" in Device 1. Device 2 holds "X:\PRDBr\PRD_COM_1".
See for yourself in this screenshot:
Unfortunately we are being confronted with the error message that you can see in the top left of the screenshot:
-24994 Runtime environment error 1, wrong path
Instead of using drive letters we also tried UNC paths like: \\server\backup\PRDBr\PRD_COM_0 and \\server\backup\PRDBr\PRD_COM_1. This leads to another error message: -24994 Runtime environment error 1, access denied
The UNC path and the network drive are perfectly accessible by the user <SID>adm in Windows Explorer.
Can you give us any support on that issue? We would greatly appreciate that :-)
Thanks so far and regards
Luis Darui replied
The account that tries to open the connection to the network share "\\server\backup" is the account that runs the MaxDB services. You can check it in the Windows Services (Start > run > Services.msc) nad find out the MaxDB service. It's usually the Local System.
You can also check with the command #sc qc "SAP DBTech-<SID>" where your <SID> is the db name. The "SERVICE_START_NAME" is the account.
If it's Local System, then the account that tries to connect to the network share is the Computer account:
Security ID: DOMAIN\COMPUTERNAME$
Account Name: COMPUTERNAME$
Account Domain: DOMAIN
Logon ID: 0x000000
It would be the case to change the user that starts the MaxDB Service to a Domain user that you can provide access in the network share or add the computer account DOMAIN\COMPUTERNAME$, but I don't think the second is the best approach.
Check the SAP Note 2068537 - Backup on network drive (Microsoft Windows) on detail and also 1377148 - FAQ: SAP MaxDB backup / recovery, point 24.
Regarding the question about the "exact time", I don't understand the purpose.