Structure-Retaining Database Copy or Restore on Windows
If the database is on several drives on Windows, problems occur as follows:
Database copy with retained structure, that is, backup_dev_type
= disk_copy | disk_standby | stage_copy | stage_standby
)
BRBACKUP attempts to copy all databases onto the drive which is
defined in the init<DBSID>.sap
parameter new_db_home
.
Restore on another computer with changed database name:
BRRESTORE attempts to reload all databases to the drive which is
defined in the environment variable SAPDATA_HOME
.
In both cases the distribution of the database files to several drives is not maintained.
For more information about solving this problem, see SAP
Note 122363
.